limiting decimal points in a fomula result

  • Thread starter Thread starter kory
  • Start date Start date
K

kory

Hi everyone,

i have a fomula and the results some of them have long
decimal results, i.e. 54.666666666667. I would it round
to 55. i tried to format the cells and the cells
referencing it, but that only changes the way it
displays. Does anyone know anything about that? Thanks.
 
Use ROUND, ROUNDUP, or ROUNDDOWN. See help.

HTH
Jason
Atlanta, GA
 
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

got #REF! with fomula PRICE() 2
Counting results of a formula 9
VLOOKUP and "-" characters 4
Round a repeating decimal from a formula... 14
To copy fomula 7
Addition errors with Decimal Places 5
Fomulas with tex and numbers in same cell 2
Copy/Fill Down in increments 1

Back
Top