| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to add an IF condition to a formula | Excel Worksheet Functions | |||
| Please Help Again-Condition Formula | Excel Worksheet Functions | |||
| Condition Formula | Excel Worksheet Functions | |||
| Add Condition to Formula | Excel Discussion (Misc queries) | |||
| Add condition to formula | Excel Worksheet Functions | |||
Linear Mode
