In A2 enter:
=--(A1<=6)

In A3 enter:
=--AND(A16,A1<12)

In A4 enter:
=--(A112)

*Note*, you have not stipulated any value for 12.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"RSVP" wrote in message
...
Excel 2003: I am using four cells A1, A2, A3 & A4. In A1 I want to enter a
value: 6, 9, 12, or 15. I want A2 to evaluate the value in A1. If the
value in A1 is less than or equal to 6 then return a '1' otherwise a '0'
{=if(a1<=6,1,0)}. I got that. However, I want A3 to evaluate the A1 value
such that if that valuse is greater than 6 but less than 12, return a 1
otherwise return a 0. For cell A3, if the value is greater than 12, return
a
1 otherwise return a 0.

Thx in advance...
--
Rick Pelham