Slight Difference in Calculation Between Spreadsheet and VBA
I am writing some functions in vba after performing the calculations on a
spreadsheet. When I compare the results, it consistently appears that the
output from the vba function is not as accurate. It seems to lose accuracy
once you get to the 7th or 8th significant digit. Does anyone know why this
happens? Thanks!!
|