Forum Discussion
Solved
If/or/and formula
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 $50...
=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.
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)
=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.
- Perfect, thank you very much