For logical function-IF(Nested)?
 

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?

For logical function-IF(Nested)?
 

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.
--
Gary''s Student - gsnu200731


"mizuzukiyu" wrote:

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?