Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Different result between airtable and excel in Multiplying decimal Formula

Topic Labels: Formulas
1336 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
Alexey_Gusev
13 - Mars
13 - Mars

811 * 39 * 561=17743869

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