Nested if statement with three variables

[kisboros]

Hi Gurus,
I have a date in V5 and an positive or negative amount in AD5.
This is what I would like to achieve:
If V5 is larger than today's date and AD5 has any amount other than zero in it, put "Current", else put "Review. Within the same expression I would also like to say that if V5 is older than today's date and AD5 is exactly zero, then put the word "Closed".

Thank you very much

[Ace_XL]

Try

=IF(V5>TODAY(),IF(AD5>0,"Current",IF(AD5=0,"Closed","Review")),"")

[kisboros]

Hi Ace,
Actually, AD5 can be either a negative or positive number, other than zero. Also, if the date is older than today and there is anegative or positive number in AD5, it has to say "Review. The "Closed" condition is only if the date is older than today AND the amount is exactly zero.
Thanks!

Try

=IF(V5>TODAY(),IF(AD5>0,"Current",IF(AD5=0,"Closed","")),"")

[kisboros]

Hi Ace,
Not quite there.
Here is a snippet of examples I would like to achieve:
Activity: End Date: Amount:
Current 6/30/2014 (100,000.00)
Current 6/30/2014 240,674.75
Closed 6/30/2009 -
Review 6/30/2009 (139,991.75)
Review 6/30/2009 14,250.00

[xwarlock10x]

sounds like you need a "AND" statements nested with "IF" statement.. try this..in cell A1 =IF(AND(V5>=TODAY(),AD5<>0),"CURRENT",IF(AND(V5<=TODAY(),AD5=0),"CLOSED","REVIEW"))
hope it works
S

Hi Gurus,
I have a date in V5 and an positive or negative amount in AD5.
This is what I would like to achieve:
If V5 is larger than today's date and AD5 has any amount other than zero in it, put "Current", else put "Review. Within the same expression I would also like to say that if V5 is older than today's date and AD5 is exactly zero, then put the word "Closed".

Thank you very much

[kisboros]

Works like a champ! Thank you very much!

[kisboros]

I sent the thanks to you, but didn't include the quote.

sounds like you need a "AND" statements nested with "IF" statement.. try this..in cell A1 =IF(AND(V5>=TODAY(),AD5<>0),"CURRENT",IF(AND(V5<=TODAY(),AD5=0),"CLOSED","REVIEW"))
hope it works
S

[FDibbins]

If V5 is larger than today's date and AD5 has any amount other than zero in it, put "Current", else put "Review. Within the same expression I would also like to say that if V5 is older than today's date and AD5 is exactly zero, then put the word "Closed".

=if(V5>today(),if(AD5<>0,"Current","Review"),if(AD5=0,"Closed",""))

(You dont specify what to do if it is exactly today's date, so I used "" at the end)

[FDibbins]

Happy to help and thanks for the feedback