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