Greater than and Less than

[Guest]

I am trying to set up a formula to tdisplay the following info
If cell a2 is greater than 2 and less than 95 enter "yes", if not, leave blank
I know how to use the if command for one part (=if(a2<2,"yes","") but can't get the second part

Can anyone help

 

[Bob Phillips]

=IF(AND(A2>2,A2<95,"yes","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Bob
you probably meant
=IF(AND(A2>2,A2<95),"yes","")

 

[Bob Phillips]

I'm going to keep out of this NG, it's not good for me.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Bob
it's just some missing bracktes <vbg>