| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
B1 Has date 12/17/07
Formula below shows 900 in B2 but doesn't change if I delete the date or change it =IF(B1"TODAY()",900,0) am I missing something excel 2003 What I am trying to do is have B2 show 900 until date 12/17/07 is reached then change to 0 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
=IF(B1TODAY(),900,0)
"politesse" wrote: B1 Has date 12/17/07 Formula below shows 900 in B2 but doesn't change if I delete the date or change it =IF(B1"TODAY()",900,0) am I missing something excel 2003 What I am trying to do is have B2 show 900 until date 12/17/07 is reached then change to 0 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
Slight change:
What I am trying to do is have B2 show 900 until date 12/17/07 is reached then change to 0 To change on the day it should be: =IF(B1=TODAY(),900,0) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Toppers" wrote in message ... =IF(B1TODAY(),900,0) "politesse" wrote: B1 Has date 12/17/07 Formula below shows 900 in B2 but doesn't change if I delete the date or change it =IF(B1"TODAY()",900,0) am I missing something excel 2003 What I am trying to do is have B2 show 900 until date 12/17/07 is reached then change to 0 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
ok then, why don't it change if I change the date to yesterday
"Sandy Mann" wrote in message ... Slight change: What I am trying to do is have B2 show 900 until date 12/17/07 is reached then change to 0 To change on the day it should be: =IF(B1=TODAY(),900,0) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Toppers" wrote in message ... =IF(B1TODAY(),900,0) "politesse" wrote: B1 Has date 12/17/07 Formula below shows 900 in B2 but doesn't change if I delete the date or change it =IF(B1"TODAY()",900,0) am I missing something excel 2003 What I am trying to do is have B2 show 900 until date 12/17/07 is reached then change to 0 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
If it is text B1 will always be greater
-- Regards, Peo Sjoblom "Sandy Mann" wrote in message ... It does for me. Are you sure that the *Date* in B1 is a real XL Date? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "politesse" wrote in message ... ok then, why don't it change if I change the date to yesterday "Sandy Mann" wrote in message ... Slight change: What I am trying to do is have B2 show 900 until date 12/17/07 is reached then change to 0 To change on the day it should be: =IF(B1=TODAY(),900,0) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Toppers" wrote in message ... =IF(B1TODAY(),900,0) "politesse" wrote: B1 Has date 12/17/07 Formula below shows 900 in B2 but doesn't change if I delete the date or change it =IF(B1"TODAY()",900,0) am I missing something excel 2003 What I am trying to do is have B2 show 900 until date 12/17/07 is reached then change to 0 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
