Forum Discussion
Holly Martin
Sep 20, 2018Copper Contributor
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?
- BobOrrellIron 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.