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?