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
MS Excel question about IF/THEN statement.?
Bascially this is what I need, but I am not sure of the formula.
In cell A2 will be a number. In cell A3 I need the formula.
Formula ...
If a2 is less than 5 then multiply a2 by 2.75,
if a2 is more than 5 and less then 8, multiply a2 by 2.25,
if a2 is more than 8 and less then 12,multiply a2 by 1.75,
if a2 is more then 12, multiply a2 by 1.5
Thank you.
2 Answers
- Joy MLv 71 decade agoFavorite Answer
=IF (A2 < 5, A2 * 2.75, IF (A2 < 8, A2 * 2.25, IF (A2 < 12, A2 * 1.75, A2 * 1.5)))
You don't to enter criteria for "more than" in the embedded if statements. If a number is less than 8, but also less than 5, it will use the then for less than 5.
