Hello,
I am looking for a formula that will select the appropriate mark up based on the purchase price I enter.
Mark Up:
<.49= 600%
.49-.99= 550%
1.00-1.99= 525%
I would like to be able to enter a price and have the formula select the mark up automatically. If I enter Widget A as having a price of $0.54, it will select the 550% mark up and apply it appropriately.
Any ideas?
I believe this will work for you... =A1*LOOKUP(A1,{0.49,1,1.99},{6,5.5,5.25})
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Or this
=INDEX({6,5.5,5.25},MATCH(A1,{0,0.49,1,1.99}))
format column B as Percent
Data Range
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks