Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date-dependent calculation
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date-dependent calculation
=IF(TODAY()DATE(2007,3,31),A1*1.04,0)
and if it not? .... above will set cell to 0 "Steve O'Donnell" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date calculation | Excel Worksheet Functions | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Results dependent on date | Excel Discussion (Misc queries) | |||
Need help with a date calculation | Excel Discussion (Misc queries) | |||
Date calculation | New Users to Excel |