software

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: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=522886
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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=522886
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: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=522886
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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=522886