IF with and OR

[PR]

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

 

[Mike H]

maybe

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

Mike

 

[PR]

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