conditional return function


Posted by Michael Kedor on March 27, 2001 3:18 PM

I'm a relatively new user, so forgive me if this is basic...cell C2 calculates a percentage for me...cell E15 needs to read that percentage, and based on the range needs to multiply cell E13 by an accelerator/decelerator...for example: If 0%<C2&LT;50% then E13*0, If 49%<C2&LT;75% then E13*.5, If 74%<C2&LT;90% then E13*.75...etc. Any help would be great, and please post responses to mikedor@hotmail.com...

thank you,
mikedor

Posted by Michael Kedor on March 27, 2001 3:20 PM

for example: If 0%<C2&LT;50% then E13*0, If 49%<C2&LT;75% then E13*.5, If 74%<C2&LT;90% then E13*.75...etc. Any help would be great, and please post responses to mikedor@hotmail.com...



Posted by Michael Kedor on March 27, 2001 3:22 PM