Name | Cost | Markup | Price |
---|---|---|---|
Can of Beans | $2.00 | 0.05 | NaN |
Cactus | $15.50 | 0.05 | NaN |
Record Player | $200.00 | 0.05 | NaN |
Box of Chocolates | $30.00 | 0.05 | NaN |
Car | $5,000.00 | 0.05 | NaN |
Markup Formula
if(prop("Cost") <= 5, .10, if(and(prop("Cost") > 5, prop("Cost") <= 20), .07, .05))
Price Formula
add(prop("Cost"), multiply(prop("Cost"), prop("Markup")))