Greater than and Less than

F

FrankG

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
 
B

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)
 
B

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)
 
Top