Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why exist a formula for excel and another for vba? pmt, payment
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/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
why exist a formula for excel and another for vba? pmt, payment
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 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "ALEX" wrote in message ... 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/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|