If formula with two condition

A

adib

Hi, in cell E9 have date 1/15/2009 i have the following formula but it
return false.please solve this what mistake i did
=IF(TODAY()-E9<45,E9+45-TODAY()&"day'
remain","")=IF(TODAY()-E9>45,TODAY()-E9-45&"day's over","")

Thank
 
B

Bob Phillips

=IF(TODAY()-E9<45,E9+45-TODAY()&"day's
remain",IF(TODAY()-E9>45,TODAY()-E9-45&"day's over",""))
 
J

Joel

You don't need an equal sign in front of the 2nd IF.


=IF(TODAY()-E9<45,E9+45-TODAY()&"day's
remain",IF(TODAY()-E9>45,TODAY()-E9-45&"day's over",""))
 
J

JLatham

You need a nested if here:

=IF(TODAY()-E9<=45,E9+45-TODAY()&" days
remain",IF(TODAY()-E9>45,TODAY()-E9-45&" days over",""))

should work for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top