This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

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

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- 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

Topic Labels:
Formulas

Solved

Jump to Solution

0
3342
8

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