Remember Me?

#1
October 27th 04, 07:51 PM
 weelittlekim Posts: n/a
how do I get a calculation to repeat various number of times?

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?

#2
October 27th 04, 08:13 PM
 Frank Kabel Posts: n/a

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

--
Regards
Frank Kabel
Frankfurt, Germany

"weelittlekim" schrieb im
Newsbeitrag ...
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Chris Excel Discussion (Misc queries) 8 January 19th 05 04:02 PM Ian Jones Excel Discussion (Misc queries) 0 January 6th 05 06:17 PM Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM Austrian Hannes Setting up and Configuration of Excel 2 December 6th 04 05:54 PM darebo Excel Discussion (Misc queries) 2 December 6th 04 05:01 PM

All times are GMT +1. The time now is 01:52 AM.