Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Different result between airtable and excel in Multiplying decimal Formula

Topic Labels: Formulas
1085 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Paul_Jang
4 - Data Explorer
4 - Data Explorer

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.