Creating a format between a range of numbers

AppSheet AppSheet Q&A
1

Hi. I’m trying to create a format between a range of numbers, for example, any number between 2 -5 will go green with an icon.

however, I’m struggling to get the expression to understand a range: I’ve tried
[Chlorine Free Level (acceptable range is 2 - 5)] = 2,3,4,5
[Chlorine Free Level (acceptable range is 2 - 5)] = 2-5
[Chlorine Free Level (acceptable range is 2 - 5)] = 2:5

What am i doing wrong?

TIA

2

@Victoria_Winder
Hope I have understood your query correctly:

AND([Chlorine Free Level (acceptable range is 2 - 5)] > 2, [Chlorine Free Level (acceptable range is 2 - 5)] < 5)

However, your searching range and the acceptable range figures are pretty much different than each other.

3

Thanks, i just edited my question, it should have read “any number between 2-5 will go green with an icon”

4

@Victoria_Winder
I have updated my expression as such. Hope it helps.

1 Like
5

[quote=“LeventK, post:2, topic:11148”]
AND([Chlorine Free Level (acceptable range is 2 - 5)] > 90, [Chlorine Free Level (acceptable range is 2 - 5)] < 180)
[/quote

LeventK:

AND([Chlorine Free Level (acceptable range is 2 - 5)] > 2, [Chlorine Free Level (acceptable range is 2 - 5)] < 5)

]

Yes that worked, thanks so much!

6

You’re welcome