I would like to set up a worksheet that will calculate based on the
following scale.

if an amount was in a specific range than the corisponding multiplier
would be used.


Example:
if part (a) costs .79 then multiply by 5.75 to come up with sale
price.




$0.00 - $0.49 6


$0.50 - $0.99 5.75


$1.00 - $1.49 5.5


$1.50 - $1.99 5.25


$2.00 - $2.49 5


Could anyone help me?

Jamey


--
nicholssvcco
------------------------------------------------------------------------
nicholssvcco's Profile: http://www.excelforum.com/member.php...o&userid=27487
View this thread: http://www.excelforum.com/showthread...hreadid=470010