You're close.

The parentheses follow the function, not precede it. Also, take out the '$',
leaving just the number,

=if(a1<today(),100,0)

If you want $ to appear, format the cell as currency.

--
Regards,
Fred


"PHEB" wrote in message
...

If anyone can help with this scenario, it would be much appreciated.

I want to compare a formula driven date with today's date in a
spreadsheet. For example, if the date in one cell has already passed,
then I want to have a value in another cell. If the date is in the
future, then the value in the aforementioned cell would be null.

Originally, I put =if(a1<()today, $100, 0), but it is obviously not
correct.

Can anyone drop a clue or two?

Thanx.

PHEB


--
PHEB
------------------------------------------------------------------------
PHEB's Profile: http://www.officehelp.in/member.php?userid=4551
View this thread: http://www.officehelp.in/showthread.php?t=1217328

Posted from - http://www.officehelp.in