IF formula help

[ashani]

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

 

[JEC]

=IFERROR(IF(OR(K2="N/A",....="N/A",G2=(DATEVALUE(K21)),"Today","Yesterday")),"")

You miss something on the dots, or the second "N/A" is unnecessary

 

[Fluff]

Maybe

=IFERROR(IF(K2="N/A","N/A",IF(G2=(DATEVALUE(K21)),"Today","Yesterday")),"")

 

[ashani]

Thank you for your quick response and help. Works absolutely fine.

 

[Fluff]

Glad we could help & thanks for the feedback.