LinkBack URL
About LinkBacks
Assuming the sale price is in A4:
Formula:
=MAX(IF(A4>25000,4000+((A4-25000)*0.1),IF(A4>5000,1000+((A4-5000)*0.15),A4*0.2)),15)
you can just paste this in row 4 of the column you want the comission in and then drag up or down to expand the formula
Assuming the sale price is in A4:
Formula:=MAX(IF(A4>25000,4000+((A4-25000)*0.1),IF(A4>5000,1000+((A4-5000)*0.15),A4*0.2)),15)
you can just paste this in row 4 of the column you want the comission in and then drag up or down to expand the formula
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks