Let's say that Qty Sold is in B2 and down. In C2:
=IF(B2<3, 0, IF(B2<6, 10, 25))
or
=10*(B2>=3)+15*(B2>=6)
The formula can be filled down.
Forum Discussion
Help creating a payout with IF formula (or any other more efficient formula)
Hi, Thank you in advance for your help with this. I need to create a payout table with the following requirements: If Qty is 3 or more (but less than 6), then the payout is $10 If Qty is 6 or mor...