Hi everyone,

Does anyone know the way to express a number range in a formula?

E.G =IF(OR(A1>1, A1<4) "example1" )

I'm trying to say if A1 is bigger than 1 and smaller than 4, so in the range of 1-4 it would equal example 1.

I have decimal numbers like 2.2 that do not apply to the rule if I use the formula >1, <4 so i'm looking for a way to include decimal numbers too!

Any help would be very appreciated!

Thank you!