Doing my head in

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'll try again, I am not explaining myself well.

I am trying to get this formula to work

=if(and(a1>1,a2>5,a2<10,"In the range","out of the range)
A1 must be greater than 1
A2 must be between 5 and ten
Simple, or is it me!!
 
=IF(AND(A1>1,A2>5,A2<10),"In the range","Out of the range")

just a bracket missing

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
=IF(AND(A1>10, A2>=5, A2<=10), "In the Range", "Out of the Range")

I put <= and >= around A2 because you said "A2 must be between 5 and ten"
If this is wrong just delete the "=" 's

Not tested, but it looked like you'd forgotten to put brackets around your AND
statement.

Dan E
 
Back
Top