Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
Rounding in Excel | Excel Worksheet Functions | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
rounding in excel | Excel Discussion (Misc queries) | |||
Rounding in Excel | Excel Discussion (Misc queries) |