how do I get a calculation to repeat various number of times?

G

Guest

Our compensation rates are built on "steps" and each step is 4.5% so if an
employee was to get two steps I would calculate their current salary times
4.5% round then multiply that answer by 4.5% and round again. I'm trying to
write a formula so the user can enter the number of steps and Excel will
calculate the new salary but I don't know how to get the calculation to
repeat, can any body help?
 
F

Frank Kabel

Hi
without the rounding for each indicidual step something like
=ROUND(A1*(1+0.045)^A2,2)
where A1 contains the base salary and A2 the number of steps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiplying the contents of two cells a variable number of times 1
Amount of Increase of Wages 8
How to round a number up or down 3
How do I create the formula for this calculation? 1
Difficult (?) average calculation 2
Calculate the number of seconds between two times 1
How do I round to the nearest $250 4
How do I get a combo box to calculate percentages in Excel? 4

Top