Hi guys,

I'm trying to get an IF statement to work based on several ranges of numbers returning text if true, being applied to a Mergefield called 'PriorityScore'.

15-25 Very High


10-14 High
5-10 Medium
1-4 Low

I wondered what the best way to do this was? I tried separate IF statements 1 after another but the values pulled only seem to be from the first statement. I then tried nesting these, but had the same issue. Wondering if I'm missing something. Here is the most recent version of the equation that I tried.

{IF {MERGEFIELD PriorityScore \* MERGEFORMAT} = > 15 "Very High" "{IF {MERGEFIELD PriorityScore \* MERGEFORMAT} = > 10 "High" "{IF {MERGEFIELD PriorityScore \* MERGEFORMAT} = > 5 "Medium" "{IF {MERGEFIELD PriorityScore \* MERGEFORMAT} = > 1 "Low"}"}"}"}

So in all cases, this equation is pulling the value 'Very High'.