why exist a formula for excel and another for vba? pmt, payment

[Guest]

Results are diferent when use pmt and payment, 0.0000000000000679456
is the diferent but exist!
0.10%
36
100

Why do you use the same formulas for VBA and Excel Front End Formulas?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1-f4a59baf4ec4&dg=microsoft.public.excel.misc

 

[Bernard Liengme]

VBA and Excel are two separate products. VBA can be used with Word,
PowerPoint, Excel, etc
Most of these have few intrinsic math functions so it is not surprising
Excel and VBA have some overlap in functions

Computers do math using binary numbers
.. Decimal numbers have to be converted to binary and back. Within the
limitations of a fixed number of digits, one get rounding errors. So doing
the calculation in two ways can results in two values that differ by an
amount that is generally totally insignificant to the problem solver (as in
your example)

Maybe you should read up on computer science a little before offering rants
like this!
best wishes