Rounding a Number

[Chris]

Hello,
I would like to find the proper function to round off a
number to the nearest whole value. For instance I need to
round 127.89 to just 128 and maintain that value when I
call if from other cells. I have used the decimal zero
option and it works great until I bring it up by
referencing it in another cell. I think it might be the
Trunc or is their something else. Please help.

Thank You

Chris

 

[Michael]

Hi Chris
If your info is in Cell A1
Try using =ROUND(A1,0)in say B1
The result should be reflected in other cells that refer
to B1
Regards
Michael

 

[JM]

Chris,

I believe ROUND() will work for you. Setting the format
of the cell to only display the integer part only effects
the display of the number. I believe that's why you are
getting the original number back when you reference it
somewhere else. If you use ROUND(,0), the number that
is stored in the cell will be changed. Then, you can
reference it anywhere else and get the rounded value.

Jim