Forum Discussion

KYWILDCT's avatar
KYWILDCT
Copper Contributor
May 24, 2023

Help with an ifs function

I am trying to add rebate % formula. I have tried nesting and if formula...was trying an ifs formula and it is still not working. What am I missing? When I try to add below 5000 for 0% I get a whole different error. 

 

=IFS(I2>5000,"3%",I2>25001,"4%",I2>50000,"5%")

  • KYWILDCT 

    The order of the arguments is incorrect. If I2 is >25000, it is also >5000, so the first value_if_true will be returned. Same for I2 > 50000.

    And if you want to return 5% as a number that can be used in calculations, don't enclose it in quotes.

     

    =IFS(I2>50000, 5%, I2>25000, 4%, I2>5000, 3%, TRUE, 2%)

     

    or

     

    =IFS(I2<=5000, 2%, I2<=25000, 3%, I2<=50000, 4%, TRUE, 5%)

Resources