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.

Turn on suggestions

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
- Struggling with what seems to be a simple IF formu...

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
673
3

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 25, 2020 11:21 AM

I have 2 fields that both sum up strings of currency. One is the sum of services and the other s a sum of the money paid in. If they total to the same, then my drawer should be balanced. The sums are the same in both fields. Originally, I had an if formula that contained the same sum action that is in {Paid In} because I would rather use an IF formula to tell me if they are the same, rather than comparing the two myself. I thought they must not be the same, so I created the {Paid In} field to check. They are indeed balanced, but the formula does not recognize this as so.

My formula:

IF({Paid In}={Gross Income},“√”,“CHECK BALANCE”)

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 25, 2020 11:34 AM

Welcome to the community, @Susan_Ferrell! :slightly_smiling_face:

The reason they’re not balancing is because you’re only seeing the “rounded” totals for both “Paid In” and “Gross Income”. If you actually change the formatting of those 2 formula fields to display more decimal points than just 2 decimal points, then you will see that there is actually a rounding difference between both of those fields.

So, one solution would be to round those numbers in your “Balance” formula like this:

`IF(ROUND({Paid In},2)=ROUND({Gross Income},2),"√","CHECK BALANCE")`

However, an even better option would be to go back to both your “Paid In” formula and your “Gross Income” formula, and apply the ROUND function to both of those formulas.

That way, your numbers will ALREADY be rounded by the time they get evaluated by your “Balance” formula.

p.s. If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. If not, please let me know what else you need help with! :slightly_smiling_face:

Reply

3 Replies 3

Solved
See Solution in Thread

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

May 25, 2020 11:34 AM

Welcome to the community, @Susan_Ferrell! :slightly_smiling_face:

The reason they’re not balancing is because you’re only seeing the “rounded” totals for both “Paid In” and “Gross Income”. If you actually change the formatting of those 2 formula fields to display more decimal points than just 2 decimal points, then you will see that there is actually a rounding difference between both of those fields.

So, one solution would be to round those numbers in your “Balance” formula like this:

`IF(ROUND({Paid In},2)=ROUND({Gross Income},2),"√","CHECK BALANCE")`

However, an even better option would be to go back to both your “Paid In” formula and your “Gross Income” formula, and apply the ROUND function to both of those formulas.

That way, your numbers will ALREADY be rounded by the time they get evaluated by your “Balance” formula.

p.s. If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. If not, please let me know what else you need help with! :slightly_smiling_face:

Reply

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

May 25, 2020 11:52 AM

Reply

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

May 27, 2020 07:53 PM

Reply