How to display value based on a range?

I have a field that sums up values from lots of previous fields. This sum ranges from 0 to 400. I'd like to have a further field that displays a particular message based on the value of that sum. For instance:

-if sum = 400, then display 'L4' 

-if sum < 400 and >=320, then display L3 

-if sum < 320 and >=240, then display L2

-if sum < 240 and >=160, then display L1

-else display = LNC

Is that possible?

Thank you!

Tony

Hello Tony, thank you for contacting our Support.

You should be able to achieve that with conditions and number field. What I mean is, you will have to store the sum into a number field:

And then by using conditions state 'less than' and 'greater than' you can create a range that you need and show appropriate fields.

For <= and >= just create an additional condition that will have 'equal to' state as well.

Let us know if this could work for you.

Thank you!

thank you, I'll try that!