limiting decimal points in a fomula result

[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.

 

[Jason Morin]

Use ROUND, ROUNDUP, or ROUNDDOWN. See help.

HTH
Jason
Atlanta, GA

 

[Kory]

dude,

you rock. thanks a lot. later.

-----Original Message-----
Use ROUND, ROUNDUP, or ROUNDDOWN. See help.

HTH
Jason
Atlanta, GA

.