Formula question

[ironsides]

I have this formula that works well

=IF(AND(J4<16,R4=1),"yes","")

But I want to change it so J4 is more than 0 and less than 16

(some cell in J are blank)

or to put it another way

J4 is between 1 and 15

Im using Excel2000

Thank you

 

[Legacy 68403]

try the followning code

if(AND(0<JJ4<16,R4=1),"yes","")

 

[ironsides]

sorry but i dont understand, can you please be more specific

 

[Domenic]

To ignore blanks...

=IF(J4<>"",IF(J4<16,IF(R4=1,"Yes",""),""),"")

For greater than 0 and less than 16...

=IF(J4>0,IF(J4<16,IF(R4=1,"Yes",""),""),"")

Hope this helps!

 

[ironsides]

Domenic works fine. Thanks and best wishes, Matt