P
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
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