#### Stephen_IV

##### Well-known Member

- Joined
- Mar 17, 2003

- Messages
- 968

I am trying to figure out a shorter formula for figuring out what a 2% increase a year would be for the first 4 years and then a 1.5% increase for the final year. I have a value in A1 i.e. 73688 in C1 I have a value from 1 to 5 telling me what the salary increase would be for that year. Thanks in advance.

Based on the salary in A1: i.e. 73688 the following year values is what I would be looking for.

75161.76

76665.00

78198.30

79762.26

80958.69

Code:

`=IF(C1=1,A1+(A1*2%),IF(C1=2,(A1+(A1*2%)+2%*(A1+(A1*2%))),IF(C1=3,(A1+(A1*2%)+2%*(A1+(A1*2%))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))))),IF(C1=4,(A1+(A1*2%)+2%*(A1+(A1*2%))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))))))),IF(C1=5,(A1+(A1*2%)+2%*(A1+(A1*2%))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))))))+(1.5%*(A1+(A1*2%)+2%*(A1+(A1*2%))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))+(2%*(A1+(A1*2%)+2%*(A1+(A1*2%))))))))))))))`