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
|