For logical function-IF(Nested)?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top