Trying to calculate commission, but rate is different depending on total sale amount.
Basically need a formula that does this...
If amount in cell a2 is more than X, then multiply by .05. If amount in cell a2 is less than X, then multiply by .045.
malk
Favorite Answer
You should be able to do it pretty easy by going to "insert function" which is that Fx just left of the fomula bar. Go to logical in category then click on "IF." Under logical test you should put something like "A2>(put the value of X here)" then under "value_if_true" put "A2*.05" and under "value_if_false" put "A2*.045" and it should work. Good luck.
Edit: If the wording of your question was correct and you want it to multiply by .05 ONLY if X is greater than A2 (and not if it's equal to it as well), then my answer is what you're looking for. If not, then just switch the false/true values and put "A2<=(put the value of x here)" in the logical test instead.
fathermartin121
What if a2=x
As your question is asked:
=if(a2>x,a2*.05,if(a2<x,a2*.045,"other amount"))
The other amount is just my marker to suggest something has to be decided by you. If there are only two outcomes just make the .045 the "if not" value.
If .05 is the commission for greater than AND EQUAL TO, write =if(a2>=x,a2*.05,a2*.045)