Rounding off problem..!

N

Neo1

Hello I'm having a problem...When a number is rounded off such as

76.25 to 76 i went to multiply the number 76 by something no
76.25...how can i change it so that it multiplies 76 not 76.25?


Thanks a lot
From Joh
 
D

daddylonglegs

Sounds like you want to use the rounded value so you need to convert t
that. You can use

=ROUND(A1,0) to round A1 to the nearest integer. If your 76.25 i
generated by a formula you could change that formula to

=ROUND(your formula,0
 
N

Neo1

Ah Right Thanks...Why do I need to put the ,0 at the end i know it work
but why is this?

Thanks a lot
From Joh
 
D

daddylonglegs

The zero indicates the number of decimal places. If you use

=ROUND(A1,1) it will round A1 to 1 decimal place, e.g. for your exampl
76.3

if you use -1 it rounds to the nearest multiple of 10

so if A1 contains 76.25

=ROUND(A1,-1) would give you 8
 
Top