I can put this formula =IF(Sheet1!A2="Y",1,"") in cell B2 so that whenever I
enter a "Y" in cell A2 a "1" will appear in cell B2. However I have two
questions. What IF Statement can I put in cell B2 so that if I enter a 24 or
less in cell A2 a "1" will appear in cell B2? What IF Statement can I put in
cell C2 so that if I enter a 25 or more in cell A2 a "1" will appear in cell
C2?

Hi
Try these two: =IF(A2<=24,1,"") in B2 and =IF(A2=25,1,"") in C2
HTH
John
"Workbook" wrote in message
...
I can put this formula =IF(Sheet1!A2="Y",1,"") in cell B2 so that whenever
I
enter a "Y" in cell A2 a "1" will appear in cell B2. However I have two
questions. What IF Statement can I put in cell B2 so that if I enter a 24
or
less in cell A2 a "1" will appear in cell B2? What IF Statement can I put
in
cell C2 so that if I enter a 25 or more in cell A2 a "1" will appear in
cell
C2?

=IF(Sheet1!A2<=24,1,"")
=IF(Sheet1!A2=25,1,"")

--
Gary''s Student - gsnu200829


"Workbook" wrote:

I can put this formula =IF(Sheet1!A2="Y",1,"") in cell B2 so that whenever I
enter a "Y" in cell A2 a "1" will appear in cell B2. However I have two
questions. What IF Statement can I put in cell B2 so that if I enter a 24 or
less in cell A2 a "1" will appear in cell B2? What IF Statement can I put in
cell C2 so that if I enter a 25 or more in cell A2 a "1" will appear in cell
C2?

Hi,

Try following: -
Enter in B2 =IF(Sheet1!A2<=24,1,"")
Enter in C2 =IF(Sheet1!A2=25,1,"")

Thanks.

--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Workbook" wrote:

I can put this formula =IF(Sheet1!A2="Y",1,"") in cell B2 so that whenever I
enter a "Y" in cell A2 a "1" will appear in cell B2. However I have two
questions. What IF Statement can I put in cell B2 so that if I enter a 24 or
less in cell A2 a "1" will appear in cell B2? What IF Statement can I put in
cell C2 so that if I enter a 25 or more in cell A2 a "1" will appear in cell
C2?