Formula for calculating price

N

nander

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%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top