Novice Needs Help with Formulas

[Donna123]

Buidling our 2006 budget. My columns are as follows:

Column A - Name
Column B - Title
Column C - Beginning Year Payrate
Column D - Projected Increase (set at 3% above Column C)
Column E - Anniversary Date (when raise is due)
Column F - Actual Increase (to be computed on anniversary date)
Columns G - R Jan, Feb, Mar, etc

Essentially, I want a formula that will look at column G-R, compare it
to Column E and then use either Column C or Column F.

Example: John Doe's anniversary is Mar 06. In column C, I have put
his beginning year payrate of $35000. Column E has $36050. So, the
columns labeled Jan and Feb should look at Column E, understand that
Jan is less than the date in Column E and use the value in Column C.
The same should be for Column H. When we get to Column I (Mar), the
formula should recognize that Column E is equal or greater to Mar and
then use the data in Column F. This would be followed for the
remaining months.

On our current budget it is a manual process to copy and paste all the
way through once raises are input.

Any help would be much appreciated!!

 

[duane]

Not sure I followed what you want becuase you have left column F blank
for now.

But, assuming Jan-Dec are in g2:r2 as date (ie 1/1/06, etc), and column
e (row 3) are also dates (3/1/06) I put this in g3 and copy thr column
r

=IF(G$2<$E3,$C3,IF($F3>0,$F3,$D3))

Note since f3 is currently blank I assumed use value in d3 until f3 is
not blank