Rounding off problem..!
 

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 not
76.25...how can i change it so that it multiplies 76 not 76.25?


Thanks a lot
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=522886

Rounding off problem..!
 

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

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

=ROUND(your formula,0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522886

Rounding off problem..!
 

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

Thanks a lot
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=522886

Rounding off problem..!
 

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 example
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 80


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522886