View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mizuzukiyu mizuzukiyu is offline
external usenet poster
 
Posts: 2
Default 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?