if,and or functions

[Guest]

Could someone please help

I like to write a formula

If Cell A =1, and Cell B= 2,3,4,5,or 6, then give me a result of 1,
otherwise 0

Thanks

 

[Sebation.G]

TRY:
=(A:A=1)*(B:B={2,3,4,5,6})*1

Hope this can be helpful

 

[Niek Otten]

=IF(AND(A1=1,OR(B1={2,3,4,5,6})),1,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Could someone please help
|
| I like to write a formula
|
| If Cell A =1, and Cell B= 2,3,4,5,or 6, then give me a result of 1,
| otherwise 0
|
| Thanks

 

[David Biddulph]

=IF(AND(A1=1,OR(B1={2,3,4,5,6})),1,0)

 

[Guest]

Assuming your A=1 value is in cell A1 and your Cell B value is in B1, this
formula should work:

=IF(B1=1,IF(B2=2,1,IF(B2=3,1,IF(B2=4,1,IF(B2=5,1,IF(B2=6,1,0))))),0)

 

[Sebation.G]

mk a mistake before ,change it here

=(A1=1)*(OR(B1={2,3,4,5,6}))