| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ERRORS IN A DIVISON FORMULA
If you change the format of K24 to General and make the column wide enough, you'll probably notice that its value is 3.013179394.
-- Kind regards, Niek Otten Microsoft MVP - Excel "thaenn" wrote in message ... |i have a formula in "cell K25" that is dividing 15,000 (Cell D25) by 3.01 | (Cell K24) and I am getting a result of 4,978.13. | | This is close to the correct answer, but not exact. The correct answer | should be 4,983.39. | | The formula is written as follows: =D25/K24 | | Any Suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Errors in "vlookups" formula | Excel Worksheet Functions | |||
| How do i make a sum formula ignore #div/0! errors in the range | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
