Forum Discussion

alekssimic's avatar
alekssimic
Copper Contributor
Oct 14, 2022

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 more then the payout is $25


Qty Sold Payout
Salesperson 1 6 ?
Salesperson 2 6 ?
Salesperson 3 5 ?
Salesperson 4 3 ?

Formulas and Functions

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 14, 2022

    alekssimic 

    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.