Different result between airtable and excel in Multiplying decimal Formula

[Paul_Jang]

Hi,
I have some problem in calculating CO2 calculation.

Calculation result values as below.

1. Excel : round( 8.110000 * 0.000039 * 56.100000 * 1.000, 6) = 17.925857
2. Airtable : round( 8.110000 * 0.000039 * 56.100000 * 1.000, 6) = 17.743869

Each data in Airtable and excel is in the field (decimal 1.000000)

It would be appreciated to help me. I think excel value would be right calculation result.

Regards
JP

[Alexey_Gusev]

811 * 39 * 561=17743869

[Hendrik_Yang]

Yes you must use Round formula to ensure the decimal is accurate.