For logical function-IF(Nested)?

M

mizuzukiyu

1) IZIT we have to memorise for the format for logical function AND, OR
e.g. IF(OR(.....),(value),)
Is there a more effective way for understanding???
izit when there are 3 IF we use IF and OR 2gether and if there are only 2 we
use OR only??

2) When we use e.g.$c$4?(for f4 function)?
izit when we look up for a fixed value?
 
G

Gary''s Student

It is not a matter of 2 or 3. If you OR a group of things it will be true if
ANY of them is true.

If you AND a group of things it will be true only if EVERY one of them is
true.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Converting URLs in comments to Markdown-formatted links 2
Use TODAY() function as the criteria in a SUMIF formula 1
Excel does not accept text format! 0
Using FIND to highlight text (with dashes) 4
A couple questions BEFORE using Office 365 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Getting Radio Buttons to work, that are inserted via AutoText 0

Top