Hi,
I'm trying to put IF statement -
IF cell K2 has N/A then put N/A otherwise put Today or Yesterday. However I'm keep getting error message when using the following syntax. Please can someone help me.
=IFERROR(IF(OR(K2="N/A","N/A",G2=(DATEVALUE(K21)),"Today","Yesterday")),"")
thank you
I'm trying to put IF statement -
IF cell K2 has N/A then put N/A otherwise put Today or Yesterday. However I'm keep getting error message when using the following syntax. Please can someone help me.
=IFERROR(IF(OR(K2="N/A","N/A",G2=(DATEVALUE(K21)),"Today","Yesterday")),"")
thank you