Hello I tried to make my own formula please tell me if this is correct:
Price:
$0-$10=20% markup
$10-50=15% markup
$50+=14% markup
=(a1 * lookup(a1,{0,10,50},{1.2,1.15,1.14})) - 0.01
Hello I tried to make my own formula please tell me if this is correct:
Price:
$0-$10=20% markup
$10-50=15% markup
$50+=14% markup
=(a1 * lookup(a1,{0,10,50},{1.2,1.15,1.14})) - 0.01
Last edited by ryanb4614; 08-08-2010 at 08:40 PM.
Why don't you tell us, you can test whether it does what you want or not.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks