how i create a interval

[demetrio29]

ex.
is like this: 100<=d18<=200 or like this: 100/d18/200

i dont know how to create?

 

[Rick Rothstein]

I think you are looking for this...

AND(D18>=100,D18<=200)

 

[Pete_UK]

Do you want something like this:

=IF(AND(D18>=100,D18<=200),"in range","outside range") ?

Hope this helps.

Pete