Help

Why "Rounddown" result is not same with Excel spreadsheets?

Topic Labels: Formulas
2025 18
cancel
Showing results for 
Search instead for 
Did you mean: 
global
5 - Automation Enthusiast
5 - Automation Enthusiast

image

Hello everyone.

I’m love to use Airtable everymonth to publish invoice and user’s portal.

Well, I found a problem with “rounddown” calculate.

When I input the date like following, the result was not correct.

Price field = 147.70
Quantity field = 50
Subtotal field[ rounddown(Price * Quantity,0) ] = 7384.00

I checked with Excel spreadsheet, the result was 7385.00 !!!

And I also checked with calc app, the result was 7385 also.

I can’t understand why it doesn’t work the same.
And I’d like to fix it ASAP.

Please help me…

18 Replies 18

Looks like a major bug with Airtable.

I would report this as a bug to support@airtable.com, but I wouldn’t hold your breath on them fixing this. I have rarely — if ever — seen them fix any bugs I have ever reported to them in years.

global
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you very much for your kindness!

I’ll adjust it by myself with hoping Airtable team to fix it;-)

You’re welcome! Be sure to email them to alert them to this!

If it’s caused by the floating point bug, it’s not likely to be fixed soon.

But doesn’t the floating point bug only crop up when you’re dealing with decimals? In this case, everything ends in .0000000 all the way to infinity. There’s no 1 at the end.

I am unable to reproduce this. What happens if you delete the values and retype them?

I’m able to reproduce this. See screenshots below.

Screen Shot 2022-10-10 at 11.46.15 PM

Screen Shot 2022-10-10 at 11.46.35 PM

Now I can reproduce it.
I’m going to go with the floating-point issue that @Bill.French pointed out.

image

My solution is to put in some intermediate rounding:
image

How can it be a floating point bug if there are no floating points?

I’m assuming that this ROUNDDOWN bug also affects ROUNDUP as well.