Thread
:
how to use if,and,or functions together in excel
View Single Post
#
2
Jason Morin
Posts: n/a
One way:
=IF(AND(A1=1,OR(B1={3,4,5,6})),"OK","NOT OK")
HTH
Jason
Atlanta, GA
-----Original Message-----
I want to create a formula as follows
IF cell x = 1, AND cell y=3, 4, 5, OR 6, then give me
answer of OK,
otherwise NOT OK
.
Reply With Quote