If formula with two condition

[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

 

[Bob Phillips]

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

 

[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",""))

 

[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.