Dec 18 2021 08:58 AM
I am looking for a formula that will help me to choose my commission on sales based as follows, will be very grateful for your urgent help
$75 | Up to $1000 |
$150 | $1001 - $ 5000 |
$225 | $5001 and above |
Dec 18 2021 09:17 AM
Dec 18 2021 12:15 PM
Thank you for the speedy reply but what I need is a self-contained formula that can return the commission value based on the variable. I started doing the formula but got stuck halfway through. Here is my attempt at it, I am sure you will be able to complete it. The formula is in B6. Please help
=IF(OR(AND($D$1>0,$D$1<1001), AND($D$1>1000,$D$1<5001)),75,150)
Dec 18 2021 12:43 PM
Solution=IF(AND($D$1>0,$D$1<1001),75,
IF(AND($D$1>1000,$D$1<5001),150,
IF($D$1>=5001,225)))
Above nested IF formula works in my spreadsheet.
Dec 18 2021 01:09 PM
Dec 19 2021 02:59 AM
Dec 18 2021 12:43 PM
Solution=IF(AND($D$1>0,$D$1<1001),75,
IF(AND($D$1>1000,$D$1<5001),150,
IF($D$1>=5001,225)))
Above nested IF formula works in my spreadsheet.