Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
excel if/then question?
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.
2 Answers
- 7 years agoFavorite 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.
- fathermartin121Lv 67 years ago
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)
