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

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!

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!

1 Like

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

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.