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
- Nesting 5 IF statements

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

Apr 16, 2022 08:37 AM

I’ve tried everything and I’m so close, but I can only seem to nest 4 IF statements and can’t find how to get up to 5.

Background: I’m trying to assign dollar signs to different price points. If a price is

- less than or equal to 50 = $
- less than or equal to 100 = $$
- less than or equal to 500 = $$$
- less than or equal to 1000 = $$$$
- more than 1000 = $$$$$

Here’s what I have that almost works:

```
IF(
{Price} <= 50,
"$",
IF(
{Price} <= 100,
"$$",
IF({Price} <= 500,
"$$$",
IF({Price} <= 1000,
"$$$$"
)
)
)
)
```

I’d like to just add one more IF in there, but I guess when I add a “>=” it messes up the code and I get an error. How do I get that just one extra step? Thanks in advance!

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

Apr 16, 2022 08:48 AM

You don’t actually need the last condition for more than 1000, because if it isn’t less than or equal to 1000, it must be more.

Here is the formula with my style of formatting to make nested `IF`

s easier to read. Note that the number of closing parenthesis matches stacked at the end matches the number of `IF`

s.

```
IF(
{Price} <= 50,
"$",
IF(
{Price} <= 100,
"$$",
IF(
{Price} <= 500,
"$$$",
IF(
{Price} <= 1000,
"$$$$",
"$$$$$"
))))
```

Reply

3 Replies 3

Solved
See Solution in Thread

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

Apr 16, 2022 08:48 AM

You don’t actually need the last condition for more than 1000, because if it isn’t less than or equal to 1000, it must be more.

Here is the formula with my style of formatting to make nested `IF`

s easier to read. Note that the number of closing parenthesis matches stacked at the end matches the number of `IF`

s.

```
IF(
{Price} <= 50,
"$",
IF(
{Price} <= 100,
"$$",
IF(
{Price} <= 500,
"$$$",
IF(
{Price} <= 1000,
"$$$$",
"$$$$$"
))))
```

Reply

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

Apr 16, 2022 09:00 AM

Thank you so much! I was driving myself crazy. I very much appreciate your help.

Reply

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

Apr 17, 2022 12:40 AM

Hi,

REPT("$", ({Price}>50)+({Price}>100)+({Price}>500)+({Price}>1000)+1)

Reply