IF statement between two values

Hi

I'm trying to get an IF statement that will give me a YES/NO result for a cell being between two values.

e.g. =IF(A1 is less than X but greater than Y say YES if not NO)

I can get the first part to work but not the second!

Hi Ozrik,

What you need is to use the AND function. Refer below for an example.

Please Login or Register  to view this content.

Hope this helps.

Originally Posted by quekbc

Hi Ozrik,

What you need is to use the AND function. Refer below for an example.

Please Login or Register  to view this content.

Hope this helps.

That works perfectly for what I need, thank you very much.