| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and VBA calculate the same formula differently
I have a strange phenomenon. In Excel the following expression: LN(8/PI()^2*280/125) equates to 0.596458. In VBA the code: Log(8/(4*Atn(1))^2*280/125 comes out to 0.554588, a difference of over 7%. I makes no difference to replace (4*Atn(1)) with 3.14, the difference is basically the same and it screws up my calculation. BTW, Log in VBA is the same as LN in Excel. Does somebody have an idea why this is and how to correct it? Thanks. Ottmar
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate differently based on original value | Excel Worksheet Functions | |||
| identify numbers and text differently in formula | Excel Discussion (Misc queries) | |||
| formula rounds differently in 2 spreadsheets | Excel Worksheet Functions | |||
| Formula behaves differently | Excel Worksheet Functions | |||
| In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) | |||
Threaded Mode
