If formula with two condition
 

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

Thanks


--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73859

If formula with two condition
 

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


--
__________________________________
HTH

Bob

"adib" wrote in message
...

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

Thanks


--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73859

If formula with two condition
 

You need a nested if he

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

should work for you.

"adib" wrote:


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

Thanks


--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73859

If formula with two condition
 

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()-E945,TODAY()-E9-45&"day's over",""))
"adib" wrote:


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

Thanks


--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73859