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!!


--
Donna123
------------------------------------------------------------------------
Donna123's Profile: http://www.excelforum.com/member.php...o&userid=26962
View this thread: http://www.excelforum.com/showthread...hreadid=401785