In column A is monthly collections. In Column B, I would like to create a formula that shows the bonus/commission amount earned.
For example: Less than $20,000 in column A, column B is $0. $28,000 - $34,999 in column A, Column B should equal $250...$35,000 - $44,999 in column A, Column B should equal $500...45,000+ in Column A, Column B should equal $1000.
This is done each month, so I would imagine once I have the first formula I can use the fill-handle to do the rest of the months.
Hi,
Was that a typo? There's a gap between 20,000 and 28,000
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.
...assuming it was a typo then maybe
Formula:
Please Login or Register to view this content.
You are a genius, thank you!!!!!! (yes it was a typo...below 28k they get no commissions)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks