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<50% then E13*0, If 49%<C2<75% then E13*.5, If 74%<C2<90% then E13*.75...etc. Any help would be great, and please post responses to mikedor@hotmail.com...
thank you,
mikedor