If you enter
1,793,413.16 in cell A1
1,793,735.11 in cell A2
Then in cell A3 type the formula =A1-A2 the answer is
-321.950000000186
Can anyone explain why it has the decimals at the end I can not figure this out.
Im using Excel 2007.
If you enter
1,793,413.16 in cell A1
1,793,735.11 in cell A2
Then in cell A3 type the formula =A1-A2 the answer is
-321.950000000186
Can anyone explain why it has the decimals at the end I can not figure this out.
Im using Excel 2007.
Have a look at the article: "Rounding Errors".
Cheers,
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks