I have a formula on my spreadsheet (Excel & OpenOffice) that looks like this: (1+(8.5/12/100))^335. The answer on both spreadsheets is 10.63927. If manually computed using a calculator, the result is still the same.
My problem is I can't get the exact output in OrbForms. The formula I used is pow((1+(8.5/12/100)),335), and the result is 10.63914.
The difference is a change in number on the 4th decimal. This may sound trivial but a difference in decimals is very important when computing interest.
Can anybody help me out on this?
Many thanks in advance.