Date-dependent calculation
Hi Steve
Try
=IF(TODAY()DATE(2007,3,31),A4*1.04,A4)
--
Regards
Roger Govier
"Steve O'Donnell" <Steve wrote in
message ...
I want a cell to show the product of the value in cell A4 X 1.04, but
only if
the actual calendar date date is past a certain date. So far, I have
=IF(??????,PRODUCT(A4, 1.04))
Can anyone help me fill in the ????. The idea would be: if we've
passed
March 31, the date displayed in this new cell would equal to 104% of
the
value in A4.
|