Forms: IF statement on Calculated text field for numeric 'range'

[katc13840706]

Hello!!!

I think this is an easy one, but I'm stuck! 

This field is formatted as Text, and the TOTAL POINTS for EVENT field is formatted as a number.

I have the first line working:

IF({DE:TOTAL POINTS for Event}>46,"Tier 1")

I can't seem to figure out how to add additional IF statements for other ranges.  These are the ranges I'm trying to add:

>46	Tier 1
30-45	Tier 2
19-29	Tier 3
10-28	Tier 4
<10	Out of Scope / Reg Only

Thank you!!!! 🙂

Kat

[skyehansen]

You need to work from smallest number to largest. Use syntax that looks similar to the one in this calculation.

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/grouping-by-issue-age/m-p/60122...

(i.e. if <10, X; else if <19, Y; else if <29, Z; and so on)

By the way I think there's a typo in tier 4.

--------------------------------

If you liked my post, please like my ideas at
https://experienceleaguecommunities.adobe.com/t5/user/viewprofilepage/user-id/17528599/contributions...

--------------------------------

[katc13840706]

Thank you, Skye!  I am going to try this - appreciate the response 🙂