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
Solved! Go to Solution.
@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.
@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.
Thanks, i just edited my question, it should have read โany number between 2-5 will go green with an iconโ
@Victoria_Winder
I have updated my expression as such. Hope it helps.
[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
]
Yes that worked, thanks so much!
Youโre welcome
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |