Rounding in Excel
 

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.
--
Egg Grader

Rounding in Excel
 

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

"egg_grader" wrote:

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.
--
Egg Grader

Rounding in Excel
 

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


"Eduardo" wrote:

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

"egg_grader" wrote:

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.
--
Egg Grader