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.
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.