Help

Re: Nesting 5 IF statements

Solved
Jump to Solution
511 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Lily_Horner_Hor
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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 IFs easier to read. Note that the number of closing parenthesis matches stacked at the end matches the number of IFs.

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

See Solution in Thread

3 Replies 3
kuovonne
18 - Pluto
18 - Pluto

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 IFs easier to read. Note that the number of closing parenthesis matches stacked at the end matches the number of IFs.

IF(
  {Price} <= 50, 
  "$",
IF(
  {Price} <= 100, 
  "$$",
IF(
  {Price} <= 500, 
  "$$$",
IF(
  {Price} <= 1000, 
  "$$$$",
  "$$$$$"
))))
Lily_Horner_Hor
4 - Data Explorer
4 - Data Explorer

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

Hi,

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