MS Excel question about IF/THEN statement.?

Question

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.

Joy M · Accepted 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.

graziose · Answer

If Then Statements In Excel

MS Excel question about IF/THEN statement.?

Related Questions

Trending Questions