View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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