Hi, quick question!
I am writing a formula. The Ragic Learning Centre says:
IF(A1.RAW=A2.RAW,‘Open’,‘Closed’)
IF(A1.RAW=“Yes”,1,0)
IF(A1=1,‘YES’,‘NO’)
Now how about IF(A1=’’,’’,1)? Do I use .RAW for no value (i.e.’’)?
Thanks again,
Kane
Hi, quick question!
I am writing a formula. The Ragic Learning Centre says:
IF(A1.RAW=A2.RAW,‘Open’,‘Closed’)
IF(A1.RAW=“Yes”,1,0)
IF(A1=1,‘YES’,‘NO’)
Now how about IF(A1=’’,’’,1)? Do I use .RAW for no value (i.e.’’)?
Thanks again,
Kane
Hi,
Yes, you’ll need to use “.RAW” in IF(A1.RAW="","",1) since empty value is not a number.