"IF" formula based on status with three possible number results

[PaintedTree_cpdg (Cribby G)]

As you can tell from the screenshot, There are three possible statuses, and I need each one to return a given value. I feel like I’m not far off with what I have, but I’m just receiving “true” for the last line of formula. What can I do to clean this up?

Thanks in advance!

[mark.anley (Green Llamas Consulting)]

Hi @PaintedTree_cpdg - I would use a SWITCH statement rather than a nested IF.

SWITCH({Tier}, “Tier 1”, “235”, “Tier 2”, “215”, “Tier 3”, “195”, “0”)

The “0” at the end is the default if there are no matches.

Hope this helps!
Mark

monday.com + Green Llamas

[PaintedTree_cpdg (Cribby G)]

Perfect, that’s all I needed. Thanks for your help!