| 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 | |||
Linear Mode
