Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Re: Formulas Automatically Rounding Up

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Solved

Jump to Solution

1
3477
1

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2020 10:10 AM

I have searched Airtable Help and Google and haven’t located a solution for the following issue:

I have created simple formulas in Currency and Number fields. The results are always rounded up. I’ve tried different options (Integer, decimal places) but they made no difference.

How do I get Airtable to show the correct result without rounding up?

Thank you!

Solved! Go to Solution.

1 Solution

Accepted Solutions

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2020 03:12 PM

Now why is the Advertising showing as a Currency not as a Formula?

When you do the Formula, go to the second tab Formatting and choose the decimals

Reply

8 Replies 8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2020 11:08 AM

Hi @Rhonda_Coats,

Welcome to Airtable Community! :grinning_face_with_big_eyes:

If you dont want the numbers to be RoundUp, then use the format Decimals with as much decimal points as you need.

BR,

Mo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2020 11:22 AM

Thank you so much for the welcome!

I tried what you suggested but it didn’t work. The results of the formula are still rounding up.

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2020 11:30 AM

Can I see the formula then? And an example of the numbers would also be great.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2020 11:35 AM

Yes, and thank you for taking the time to look at this.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2020 02:07 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2020 02:27 PM

there should be decimals, the result is $18.57, not $19.00 even.

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2020 03:12 PM

Now why is the Advertising showing as a Currency not as a Formula?

When you do the Formula, go to the second tab Formatting and choose the decimals

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 14, 2023 08:17 AM