Unclear instance for using .RAW


#1

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


#2

Hi,

Yes, you’ll need to use “.RAW” in IF(A1.RAW="","",1) since empty value is not a number.