How to make a number round up/down to a set number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i would like to have a set of prices round up or down to the nearest ninth.
for example, 1.15 turns into 1.19. 2.41 turns into 2.39
 
David,

For a number in cell A1

=ROUND(A1,1) -0.01

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Alternate Rounding Up & Down of .50 in a column 5
Round Function 5
Rounding number to the nearest quarter 1
rounding up to the nearest 1000 1
rounding 2
Rounding numbers up or down in same formula 6
Rounding Time to Nearest 5 Minutes 1
Formula help - rounding up and round down? 2

Back
Top