Mulitple IF cell

[Grinch]

Here's my deal. Here's what I want but don't know how to formulate it.

If E7 is greater than 4.9, then B7 * .4
If E7 is greater than 5.9, then B7 * .6
If E7 is greater than 6.9, then B7 * .8
If E7 is greater than 7.9, then B7 * 1

Thanks in advance for your help... I'm losing my mind.

 

[Marcelo Branco]

Pedie,

You could say that the formula would produce wrong results with 7.91, for example, but, i think, to fix it is just a case of using the proper limits, depending on the possible values of E7.

M.

 

[pedie]

Okay, thanks again.

Pedie,

You could say that the formula would produce wrong results with 7.91, for example, but, i think, to fix it is just a case of using the proper limits, depending on the possible values of E7.

M.

 

[T. Valko]

Thanks!!!!!

You're welcome!