View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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.