Forum Discussion

Holly Martin's avatar
Holly Martin
Copper Contributor
Sep 20, 2018

Function in Excel

I'm not very well-versed in Excel, so sorry. What I need is:

 

If a number in a cell (a sum of the day's sales) is greater than 250 to multiply it by 10%; if it is greater than 450 multiply it by 15%. If it is less than 250, not do anything. 

 

Is this possible? 

  • BobOrrell's avatar
    BobOrrell
    Iron Contributor

    Holly,

    Assuming the breakdown is actually 0-249.99, 250-449.99, 450 and up.  You can use the formula below, and just change all 4 instances of A1 to the cell where your sum is located.

    =IF(A1<250,0,IF(A1>=450,A1*0.015,A1*0.01))

    In Office 365, there is also an IFS function, that can apparently make it a little cleaner, but my employer has office 2016, so I haven't been able to play around yet.

Resources