|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Using a date (datevalue) to trigger adding a value to a cell
Thanks very much for your help.
"Max" wrote:
One way ..
Put in B1:
=SUM(50000,500*INT((ROWS($1:1)-1)/6))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ashman" wrote:
I have a list of the months over the next 3 years in column A (format is
01-Jan-08). Next to that list there is another list of values (starting at
$50,000) next to each date. In January and July each year (except for Jan
08), I want $500 added to the $50,000, so by the end of the 2nd year, the
value is $52,000. Do I use DATEVALUE in an IF or something else? Below is
an example of what I mean. Please help!
A B
1 1-Jan-08 50000
2 1-Feb-08 50000
.
.
6 1-Jun-08 50000
7 1-Jul-08 50500
.
.
12 1-Dec-08 50500
13 1-Jan-08 51000
|