Forum Discussion
Umesh_3296
Oct 30, 2019Copper Contributor
Divide Operation in excel with precision
Hi,
I have to divide a two numbers with 6 digit precision .
e. g have to divide 8843324.87 by 1.075112 but when using simple formula with cell reference like =C2/D2 getting #Value error..
how can i get the result with 6digit precision ??
1 Reply
Sort By
- Riny_van_EekelenPlatinum Contributor
Make sure both your numbers are in fact numbers. I.e. that they are not accidentally entered as text. They could contain leading or trailing spaces in case you copied ot imported them from another document. Dividing a number by text or a text by a number will give you the value error.
You can format any number to display up to 30 decimals. If you want to calculate with 6 digits precision you need to use =ROUND(C2/D2,6)