I am attempting to create an incentive report to track incentives paid to an employee based on business closed. I have to show that for every $1,000,000 of assets, this employee gets a $1,000.00 incentive. I have two columns that show annuities plus AUM dollar figures that we are basing this incentive on. How can I show that for every $1,000,000 recognized in Excel from the sum of these totals, it will automatically show a $1,000 incentive? Please advise. Thanks!
Last edited by tylermprice; 08-04-2020 at 04:27 PM. Reason: requested
this looks like it would be one way...
=IF(ROUNDDOWN(A2,1-LEN(INT(A2)))*0.001< 1000,"",ROUNDDOWN(A2,1-LEN(INT(A2)))*0.001)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you for this. Could you please explain though how my two sets of data showing the sales numbers closed would play in to this? For example, if I have one column that shows annuities closed totalling $700k and another column for AUM totaling 500k, this would be $1.2 mil in business, which would equal a $1,000 incentive. How can the formula you posted add up the annuity and AUM totals to calculate the incentive earned? Hope this makes sense. Thanks again
to put simply, did you post a sample workbook or did I have to guess based on what you posted in post #1? I based my guess based on your post since you did not post any actual data with expected results. Since we are not mind readers on this forum when given limited information we make guesses based on what we read. If the formula offered isn't what you need for your data then I would suggest that you follow the instructions in banner at the top of the post and upload a REPRESENTATIVE sample WITH expected results so we can better meet your requirements.
Assuming amount in F15
It is rounding down amount till each 1.000.000
=FLOOR(F15,10^6)
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks