Rounding in Excel

  • Thread starter Thread starter egg_grader
  • Start date Start date
E

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.
 
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
 
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.
 
Back
Top