rounding to a specific number

G

Guest

when caluclating retail prices, with various costs and various gross margins
want to make the calculation and then the last digit ends in say 9. So if
actual calculation's last digit is 0-5 it would round down to nearest 9; or
 
G

Guest

Assume the unrounded price (e.g., 123.34) is in cell A1.

=IF(MOD(A1*100,10)>5,TRUNC(A1,1)+0.09,TRUNC(A1,1)-0.01)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get price calculations to always end in 9? 5
Need formula to round number up to always end in X.X9 6
Need help implementing EPA rounding method 17
specific rounding of formulas which may need to include an IF stat 2
Rounding numbers up or down in same formula 6
How do I round a 4 digits number to it's nearest 10 2
rounding a formula's number 2
Rounding Error 4

Top