Converting Lotus too Excel

[JoeLegg91]

I'm copying formulas from lotus to excel and they are just basic formulas summing inputs and for some reason the majority of the totals are off by 1 or 2 , and I'm really confused because the inputs are correct and not all of the totals are off by 1 or 2 , can someone tell me why and how I might be able to fix this issue?

 

[Dave Patton]

Please provide some examples of your data and your formulas.

You can use the forum's took XL2BB to post an extract of your spreadsheet.

 

[jasonb75]

can someone tell me why and how I might be able to fix this issue?

Without having both versions to scrutinise we can only really guess. Rounding might be one possibility. Differences in formula default behaviour would be another.