If Then Question Regarding Dates

P

PHEB

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
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 th
future, then the value in the aforementioned cell would be null.

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

Can anyone drop a clue or two?

Thanx.

PHE
 
D

Dave F

=IF(A1>TODAY(),100,0) Will only work if A1 is formatted as a date, I believe.

Dave
 
F

Fred Smith

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.
 
Top