If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|