Rounding in Excel

[egg_grader]

When I enter a number into a cell that has a formula I am using the results
are not accurate. For example when I enter a number 946399, I get a result
of 2628. The result I need to get is 2629. My problem is when the decimal
is .5 or greater the result is rounded down to the nearset whole number. By
using a calculator I get 2628.8861. My answer I am looking for should be
2629. Can you help? I am using MS Excel 2007. The formula I am using is
=QUOTIENT(G172,G171). Where cell reference g2 is a random number I enter,
and cell refernce g1 is a 360.

 

[Eduardo]

Hi,
Result from your formula is correct because Quotient Returns the integer
portion of a division. Use this function when you want to discard the
remainder of a division

to get the results you want, just do

=G172/G171

Format the cell with not decimals

if this helps please click yes, thanks

 

[NBVC]

When I enter a number into a cell that has a formula I am using th
results
are not accurate. For example when I enter a number 946399, I get
result
of 2628. The result I need to get is 2629. My problem is when th
decimal
is .5 or greater the result is rounded down to the nearset whol
number. By
using a calculator I get 2628.8861. My answer I am looking for shoul
be
2629. Can you help? I am using MS Excel 2007. The formula I am usin
is
=QUOTIENT(G172,G171). Where cell reference g2 is a random number
enter,
and cell refernce g1 is a 360.

Try instead:

=ROUND(G172/G171,0)

Quotient returns integer part of division... it doesn't round

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[egg_grader]

That helped quite a bit. The answer might have been technically correct but
the result is not what I wanted. So from now on I will use the "/" when i
want to have a different result. Thanks again.

 

[egg_grader]

Thank you it was helpful.
--
Egg Grader

Try instead:

=ROUND(G172/G171,0)

Quotient returns integer part of division... it doesn't round.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)