how i create a interval
 

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

i dont know how to create?

how i create a interval
 

I think you are looking for this...

AND(D18=100,D18<=200)

--
Rick (MVP - Excel)


"demetrio29" wrote in message
...
ex.
is like this: 100<=d18<=200 or like this: 100/d18/200

i dont know how to create?

how i create a interval
 

If you are trying to define a condition, try =AND(D18=100,D18<=200)
--
David Biddulph

"demetrio29" wrote in message
...
ex.
is like this: 100<=d18<=200 or like this: 100/d18/200

i dont know how to create?

how i create a interval
 

Do you want something like this:

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

Hope this helps.

Pete

On Sep 23, 10:40*pm, demetrio29
wrote:
ex.
is like this: 100<=d18<=200 or like this: 100/d18/200

i dont know how to create?