Skip to main content

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


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


Reply