Formula for calculating price
 

I need a one cell formula that calculates a price based on the following
conditions

Items costing the Contractor $50 or less are marked up 100% witha
profit margin on the selling price of 50%
items costing 50.01 to 100 are marked up 80% with a profit margin on
selling price of 44.44%
items costing over 100 are marked up 60% with a profit margin on the
selling price of 37.50%


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=393050

One way:

=A1*LOOKUP(A1,{0,2;50.01,1.8;100.01,1.6})




In article ,
nander wrote:

I need a one cell formula that calculates a price based on the following
conditions

Items costing the Contractor $50 or less are marked up 100% witha
profit margin on the selling price of 50%
items costing 50.01 to 100 are marked up 80% with a profit margin on
selling price of 44.44%
items costing over 100 are marked up 60% with a profit margin on the
selling price of 37.50%