Thread: Formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
politesse politesse is offline
external usenet poster
 
Posts: 8
Default 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