Different result between airtable and excel in Multiplying decimal Formula

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

811 * 39 * 561=17743869

1 Like

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.