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
- IF + SWITCH formula with a non-numeric True / Fals...

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
713
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

Sep 17, 2020 07:08 AM

IF + SWITCH formula can’t have a non-numeric value as True / False argument. If it does, the result of this formula is going to be ALWAYS non-numeric and thus can’t never be used as an input for calculation in subsequent formulas.

For instance, if I have IF(Column1=“ABCD”,999999,“nonsense”)… the result of this formula is always non-numeric, no matter what the result. Even if the result is TRUE (that is Column contains ABCD), the result of the formula is non-numeric text 999999.

To get numeric result, I have to change the formula to IF(Column1=“ABCD”,999999,“000000000000000”) and then I’ll get 999999 as numeric result.

Same goes for SWITCH formula.

This is an issue when the result of the IF or SWITCH formula is an input or variable in a subsequent formula because the result of the subsequent formula(s) produces an #ERROR!

This is not a show-stopper but reduces the usability if I can’t have text “nonsense” as the result if the result of first formula is FALSE.

What we need is the first formula to produce a numeric result 999999 and text result “nonsense”, so that the subsequent formula(s) will still work when it receives the input 999999 from the first formula.

Hope I expressed it clearly.

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

Sep 17, 2020 07:45 AM

OK solved.

Incredible, why do I need another formula to convert it to number. Crazy. It only increases the size to already massive formulas I have. It will take a rocket scientist to fix the formulas one day if they break …

Here is the solution … Need another formula…

VALUE({NumberIWant}&’’)

1 Reply 1

Solved
See Solution in Thread

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

Sep 17, 2020 07:45 AM

OK solved.

Incredible, why do I need another formula to convert it to number. Crazy. It only increases the size to already massive formulas I have. It will take a rocket scientist to fix the formulas one day if they break …

Here is the solution … Need another formula…

VALUE({NumberIWant}&’’)