IF with and OR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top