VLisp Calc. vs. Excel Calc.

[Ahankhah]

Hi everybody,

 

I am converting some excel formulas to Visual Lisp.

 

I found a difference between results of a same follwing formula:

(I changed cells to numbers to simplify the problem.)

 

in Excel:                  

=0.6*2400*1.15*1170*1.1/100000 ---> result: 21.31272

In AutoLISP:           

(/(* 0.6 2400.0 1.15 1170.0 1.1) 100000.0) ---> result: 21.3127

 

While AutoLISP isn't as correct as Excel.

 

Any help to get a result like Excel is appreciated.

 

 

Edited December 23, 2020 by Ahankhah

[myloveflyer]

 (rtos (/(* 0.6 2400.0 1.15 1170.0 1.1) 100000.0) 2 10)
"21.3127200000"

[Ahankhah]

myloverflyer,

 

thanks a lot for your favor.