Need Help With "If" Formula When Multiple Conditions

[Pantherlicious]

Hello all. I need help with structuring the following formula. I am praying it's possible. It goes like this

For any given cell, if a value is less than 15, I need to multiple by .75. If the value is greater than 15 and less than 60, I need to multiply by .80. If the value is greater than 60, I need to multiple by .85.

So essentially I need the formula to check the cell value against 3 "Ifs" and provide the appropriate answer based on which group it falls into.

Is this possible? Thanks!

[JohnTopley]

TRY

=IF(B2<15,C2*0.75,IF(B2<60,C2*0.8,C2*0.85))

C2 is value to be multiplied

B2 is value being tested

[dflak]

Try this: =IF(A2>60,0.85,IF(A2>15,0.8,0.75))*A2

The if statement determines the multiplier. If statements stop as soon as they hit the first true condition. So we don't have to check if the value is between 15 and 60. If it's over 60 use .85 and stop. Otherwise check to see if it's over 15 and use .80 and stop when all else fails (in other words 15 or less) use .75.

[AlKey]

Or this

=A1*LOOKUP(A1,{0,15,60},{0.75,0.8,0.85})

v	A	B
1	80	68
2	15	12
3	14	10.5
4	12	9
5	61	51.85
6	60	51

[Pantherlicious]

Wow, and to think there were multiple solutions. AlKey, yours seems to be the simplest.