Ahankhah Posted December 23, 2020 Share Posted December 23, 2020 (edited) 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 Quote Link to comment Share on other sites More sharing options...
myloveflyer Posted December 23, 2020 Share Posted December 23, 2020 (rtos (/(* 0.6 2400.0 1.15 1170.0 1.1) 100000.0) 2 10) "21.3127200000" 1 Quote Link to comment Share on other sites More sharing options...
Ahankhah Posted December 23, 2020 Author Share Posted December 23, 2020 myloverflyer, thanks a lot for your favor. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.