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