IF with and OR
 

Can anyone help I trying to get a OR statement to work with and if
statement...

what I am trying to do is if cell K8 is = 2 and P8 is =1 mark cell j8 with
a win else not, what I am also trying to do is say in the same statement if
K8 =1 and P8 =2 then mark cell j8 with win else not...

=IF(AND(K8=2,P8=1),"Win","Not")

can anyone help...

Paul

IF with and OR
 

maybe

=IF(OR(AND(K8=2,P8=1),AND(K8=1,P8=2)),"Win","N ot")

Mike

"PR" wrote:

Can anyone help I trying to get a OR statement to work with and if
statement...

what I am trying to do is if cell K8 is = 2 and P8 is =1 mark cell j8 with
a win else not, what I am also trying to do is say in the same statement if
K8 =1 and P8 =2 then mark cell j8 with win else not...

=IF(AND(K8=2,P8=1),"Win","Not")

can anyone help...

Paul

IF with and OR
 

thanks very much, thats great... it is where you put the OR...