# If formula with greater than resulting in a text

Topic Labels: Formulas
Solved
810 2
cancel
Showing results for
Did you mean:
6 - Interface Innovator

I am trying to do a formula where I have a row with numbers (=calculation field/column) and depending on the number a certain text value (Tier 0 / Tier 1 / Tier 2 / Tier 3) should be the result in my formula field

Tier 0 : 500,000 - Unlimited
Tier 1: 100,000 - 500,000
Tier 2: 40,000 - 100,000
Tier 3: 500 - 40,000

I tried several approaches but none of them worked, I always get an error message.

IF( {Calculation} < 40000, "Tier 3", IF( {Calculation} < 100000, "Tier 2", IF( {Calculation} < 500000, "Tier 1" , IF( {Calculation} < 100000000, "Tier 0"))))

OR

IF({Calculation} < 40000, “Tier 3”, IF({Calculation} < 100000, “Tier 2”, IF({Calculation} < 500000, “Tier 1”, “Tier 0”)))

OR

IF({Calculation} < 40000, “Tier 3”, IF({Calculation} > 40000, “Tier 2”, IF({Calculation} > 100000, “Tier 1”, IF({Calculation} > 500000, “Tier 0”, “n.a”))))

Any ideas what I did wrong?

Thanks 🙂

1 Solution

Accepted Solutions
11 - Venus

The error may be due to a mixture of and .
Use " for all of them.

Either one.

``````IF(Calculation>=500000,"Tire 0",
IF(Calculation>=100000,"Tire 1",
IF(Calculation>=40000,"Tire 2",
"Tire 3"
)
)
)

IF(Calculation<40000,"Tire 3",
IF(Calculation<100000,"Tire 2",
IF(Calculation<500000,"Tire 1",
"Tire 0"
)
)
)``````

2 Replies 2
11 - Venus

The error may be due to a mixture of and .
Use " for all of them.

Either one.

``````IF(Calculation>=500000,"Tire 0",
IF(Calculation>=100000,"Tire 1",
IF(Calculation>=40000,"Tire 2",
"Tire 3"
)
)
)

IF(Calculation<40000,"Tire 3",
IF(Calculation<100000,"Tire 2",
IF(Calculation<500000,"Tire 1",
"Tire 0"
)
)
)``````

6 - Interface Innovator

thanks 🙂