Skip to main content

Different result between airtable and excel in Multiplying decimal Formula

  • January 4, 2022
  • 2 replies
  • 22 views

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

2 replies

Alexey_Gusev
Forum|alt.badge.img+25

811 * 39 * 561=17743869


Forum|alt.badge.img+18
  • Inspiring
  • January 5, 2022

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