Hoping someone out there can help with the attached.
Formula for cell B18.
The budgetary additional charge (B18) is dependent upon the number of additonal changes (B3).
The more changes that are made the higher the charge ....... see column C for splits.
Minimum charge is to be 3,000 and the maximum 30,000
Any help is much appreciated.
Like this maybe? You can have the formula create the bonus directly without needing all those calculations in B6:B15. I've created two formulas, the one in B18 uses your chart, the one in B20 does the math on its own.
EDIT: Added a 3rd formula showing how to do all the work in one cell, no chart needed. Personally, I would use formula #2.
Last edited by JBeaucaire; 07-09-2009 at 05:14 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thankyou very much .......
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Carl1966 
Register To Reply
Bookmarks