A1=2 How to set formual court If A1>1 and A1<3 = 1, If A1>3 and A1<5 =0
B Bob Phillips Nov 13, 2006 #2 =IF(AND(A1>1,A1<3),1,IF(A1<5,0<"You didn't say what happens when A1 >=5")) As I said, what about A1>=5, and also A1=3 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=IF(AND(A1>1,A1<3),1,IF(A1<5,0<"You didn't say what happens when A1 >=5")) As I said, what about A1>=5, and also A1=3 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
B Bob Phillips Nov 13, 2006 #3 typo =IF(AND(A1>1,A1<3),1,IF(A1<5,0,"You didn't say what happens when A1 >=5")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
typo =IF(AND(A1>1,A1<3),1,IF(A1<5,0,"You didn't say what happens when A1 >=5")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
