Jul 12, 2023 01:34 AM - edited Jul 12, 2023 02:08 AM
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 🙂
Solved! Go to Solution.
Jul 12, 2023 02:21 AM
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"
)
)
)
Jul 12, 2023 02:21 AM
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"
)
)
)
Jul 12, 2023 04:29 AM
thanks 🙂