agraano
07-31-2010, 11:37 AM
MsgBox (821.557 - 456.554) - 365.003
Cells(9, 1).Value = 800.557 - 400.111 - 400.446
Cells(10, 1).Value = 800.225 - 400.111 - 400.114
The above is some test codes (i created to debug my original code).
Technically, the result of the calculation should be a zero. however, i get something like the following:
0.00E+00
5.6843418860808E-14
Can anyone help to get the calculation right?
Cells(9, 1).Value = 800.557 - 400.111 - 400.446
Cells(10, 1).Value = 800.225 - 400.111 - 400.114
The above is some test codes (i created to debug my original code).
Technically, the result of the calculation should be a zero. however, i get something like the following:
0.00E+00
5.6843418860808E-14
Can anyone help to get the calculation right?