Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
weelittlekim
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
How do I limit the number of times an Excel workbook can be opene. Chris Excel Discussion (Misc queries) 8 January 19th 05 05:02 PM
Countif("between start/end times) Ian Jones Excel Discussion (Misc queries) 0 January 6th 05 07:17 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 05:21 AM
Can the number of times undo is used in Excel 2002 be increased? Austrian Hannes Setting up and Configuration of Excel 2 December 6th 04 06:54 PM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"