Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Pricing Column rounding to .95

Topic Labels: Formulas
199 2
Showing results for 
Search instead for 
Did you mean: 

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?

2 Replies 2

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.