Nested IF and AND and more IFs

[chico.corrales]

Hi Guys,

i'm currently working on a table, that has one column (D) to check the
dates on the previous (3) columns (A-C), i'm having difficultly trying to
combine multiples IF + AND function, i always come up with the wrong
result.

i have attached the sample file, hoping for your suggestions.


Thanks in advance.

Chico

[Fotis1991]

Which is the condition for "NEW" result? Because in D2 you say that the expected result is "LIVE", but in you formula that you tried...=IF(AND(A2>TODAY()-10,B2=""),"New"....the expected result looks to be "NEW"....

[acerrhod]

Try this,
=if(and(today()-10<=a2,and(b2="",c2="")),"new",if(and(a2<>"",and(b2="",c2="")),"?",if(and(a2<>"",c2<>""),"live",if(and(a2<>"",b2<>""),"ok",""))))

[chico.corrales]

Hi Acerrhod,

Your formula works !!! i tried it..

btw...how's AUH now? i miss tourist club area in abu dhabi.

Thanks,

Diego