
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 04, 2022 10:09 AM
Hi,
I have some problem in calculating CO2 calculation.
Calculation result values as below.
- Excel : round( 8.110000 * 0.000039 * 56.100000 * 1.000, 6) = 17.925857
- 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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 04, 2022 04:50 PM
811 * 39 * 561=17743869
Reply

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 05, 2022 12:44 AM
Yes you must use Round formula to ensure the decimal is accurate.
