IF OR test? two conditions, two outcomes

[Honeyfoot]

Hi,

I'm trying to figure out how to do:

=IF(Table1[@Date]=TODAY(),"TODAY","")

=IF(Table1[@Date]=TODAY()-1,"YESTERDAY","")

in one cell. Can anyone help?

Much appreciated

H

[Pete_UK]

Try this:

=IF(Table1[@Date]=TODAY(),"TODAY",IF(Table1[@Date]=TODAY()-1,"YESTERDAY",""))

Hope this helps.

Pete

[Honeyfoot]

Golly, thank you very much. I think the penny has just dropped on the logic to IF.

essentially, if(condition1true, value1, if(condition2true, value2), if(condition3true, value3, ""))) Would that be correct?

Excellent forum. Forgive me, all, if I pester you. Crash-coursing excel.

Honeyfoot

[Pepe Le Mokko]

The parenthesis after your second "If" and the last parenthesis are not necessary, but you have the overall idea
if(condition1true, value1, if(condition2true, value2, if(condition3true, value3, ""))

[Pete_UK]

You need 3 closing brackets at the end.

Hope this helps.

Pete

[Pepe Le Mokko]

THis one only has 2 and it works ?? =IF(A1="x","x",IF(A1="y","y","z"))

[Pete_UK]

Yes, but in post #3, and in your reply to it, there are 3 IF functions.

Pete