Priority Level Based on Whether a Number is Higher or Lower

Sierra A.

Hello,

I am trying to write a formula that will calculate priorities as such:

If Live Count = <15,000 return Critical to Priority column

If Live Count = <10,000 return High to Priority column

If Live Count = <5,000 return Moderate to Priority column

If Live Count = >5,000 return Low to Priority column

Gillian C

Hi @Sierra A.

So when you are doing your nested if you need to think about the boundaries of your formula.

On reading the information above I think you are meaning the following?

Critical category is 'Greater than or equal to 15,000'

High category is 'Greater than or equal to 10,000, but less than 15,000'

Moderate category is 'Greater than or equal to 5,000 but less than 10,000'

Low category is 'Less than 5,000'

Assuming that is the case, try the following:

=IF([Live Count]@row >= 15000, "Critical", IF(AND([Live Count]@row >= 10000, [Live Count]@row < 15000), "High", IF(AND([Live Count]@row >= 5000, [Live Count]@row < 10000), "Moderate", "Low")))