| 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
Meant to have said
To add to what Sandy just said xxxxxxxxxxxxxxxxxxxxxxxxxxx Peo "Peo Sjoblom" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
Did a repair on excel and now it works. go figure! Thanks for all the help
"Peo Sjoblom" wrote in message ... Meant to have said To add to what Sandy just said xxxxxxxxxxxxxxxxxxxxxxxxxxx Peo "Peo Sjoblom" wrote in message ... 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 | |
|
|
Linear Mode
