I am building a competitive pricing sheet and have a pricing column that is formulated to give me pricing based on a specific margin, however, I then need a column that would round that pricing to the .95.
Does anyone have something like this?
Pricing Column rounding to .95
+2If the price for an item, including your margin, were $10.50 what price do you want the formula to produce? What about $1.25?
If the answers are $10.95 and $1.95 then you could use
ROUNDUP(price,0) - 0.05
Is that what you’re going for?
If the price for an item, including your margin, were $10.50 what price do you want the formula to produce? What about $1.25?
If the answers are $10.95 and $1.95 then you could use
ROUNDUP(price,0) - 0.05
Is that what you’re going for?
That is the one. Thank you, Chris.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.