LinkBack URL
About LinkBacks
Dear Experts Help me!
I have a column of Units sales and a Column for the bonus.
For every 30 units sales, I want to give a $1 bonus.
For 65 units $2
For 95 units $3 and so on.bns.JPG
Using IF for bonus calculation
Dear Experts Help me!
I have a column of Units sales and a Column for the bonus.
For every 30 units sales, I want to give a $1 bonus.
For 65 units $2
For 95 units $3 and so on.bns.JPG
That's not an explanation. Where to give the bonus? how? etc. Explain properly
Click the * to say thanks.
Hi, and welcome to the forum
=INT(B2/30)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
"For every 30 units sales, I want to give a $1 bonus."
It's a simple equation.
Bonus = INT(Sales / 30)
If the results are not what you want then you need to explain more as this works exactly as you've requested.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Take my gratitude, everyone, for solving the problem. Since this is my very first post in this forum, I will try to explain the details from the following posts.
Thank you so much again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks