So I was able to figure out a a multi-cell solution to the following but I couldn't figure out how to combine it into one.
Basically I need a single formula that Calculates the following:
An entire sales bonus if an employee receives $500 if sales hit $750k and $500 more for every $100k in additional Sales. So an employee with $950k in Sales would receive a $1.5k bonus.
Any idea on how to do this?
Thanks!
Hi -
Try this:
=(ROUNDDOWN((A1-750000)/100000,0)+1)*500
Where A1 is the location of the sales figure.
Hope this helps.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
Removed by JT
Last edited by JohnTopley; 02-01-2017 at 05:58 PM.
My suggestion:
=(FLOOR((A1-650000)/100000,1))*500
_________________
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!)
Or try:
=INT(MAX(0,A1-650000)/100000)*500
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks