Need a FORMULA to round off

[Koji]

I have a question, quite simple but complicated for a
beginner like me.

Say I have a figure .... 16 in CELL A1
and in

C1 5.05263158
C2 6.73684211
C3 4.21052632

but wanted the numbers to be rounded to the nearest
Hundredth totaling it to be the number A1? How can I do
that?

I mean if I just do the math it should look like this

C1 5.05
C2 6.75
C3 4.20


Please help and thank you in advance.

 

[Frank Kabel]

Hi
try
=ROUND(value,2)

 

[JE McGimpsey]

One way:

=ROUND(C1*20,0)/20

You're really not rounding to the nearest hundredth, but rather to the
nearest 0.05.

 

[Koji]

Thank you very much, this works great.

-----Original Message-----
One way:

=ROUND(C1*20,0)/20

You're really not rounding to the nearest hundredth, but rather to the
nearest 0.05.


.