Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Different result between airtable and excel in Multiplying decimal Formula

Topic Labels: Formulas
336 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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 2

811 * 39 * 561=17743869

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