Need help making this into a formula

Posted by Lori on August 15, 2001 2:27 PM

Can anyone help?

Does someone know how to put this in to a formula?

If C13 is less than 80%, then C14 should be 0-
If C13 is between 85%-90%, then C13 should be multiplied by .320
If C13 is between 90-95%, then C13 should be multiplied by .520
If C13 is between 95%-100%, then C13 should be multiplied by .780

Thanks, Lori

Posted by Bryan Harris on August 15, 2001 2:38 PM

Enter the Formula in C14 as follows:

=IF(C13>=95,C13*0.78,IF(C13>=90,C13*0.52,IF(C13>=85,C13*0.32,0)))

Posted by Lori on August 15, 2001 3:06 PM

Need a little more help

Brian, thanks for your quick response. I entered what you gave me into the cell, but no matter what, it comes up 0.00% Have I done something incorrect or is a parameter missing or something? I'm very new to this so I'm pretty clueless.

Posted by IML on August 15, 2001 3:44 PM

Re: Need a little more help

Hi Lori,
What should happen if C13 is between 80% and 84.999%?

Posted by IML on August 15, 2001 3:55 PM

Re: Need a little more help

Assuming you want anything 80 through less than 90 at 32% try this in D13
=HLOOKUP(C13,{-999999,0.8,0.9,0.95;0,0.32,0.52,0.78},2)*C13
Assuming you want anything 85 through less than 90 at 32%, try
=HLOOKUP(C13,{-999999,0.85,0.9,0.95;0,0.32,0.52,0.78},2)*C13

good luck

Posted by IML on August 15, 2001 4:03 PM

Without reinventing the wheel

Brians works fine, too. Just change 95 to .95, 90 to .9, etc. to properly compare your percent.

Good luck

Posted by Lori on August 15, 2001 4:42 PM

Thanks for the extra info

I will try it out tomorrow when I get to work and let you know what happens.