More questions...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help me to determine the score of the following:

If Cell 13=1, score = 3 OR
If Cell 13= 5 AND Cell 14 = 1, score = 2 OR
If Cell 15 = 5 or DK, score = 0 OR
All others, score = 1

Thanks!
 
Hi

=IF(A13=1,3,IF(AND(A13=5,A14=1),2,IF(OR(A15=5,A15="DK"),0,1)))

Cheers
JulieD
 
You must log in or register to reply here.

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

Similar Threads

Formula help required 2
Excel Applying Code to a Column 0
Scoring a result in a cell 4
Sports summary sheet - think I put this in wrong place originally 1
How to link option box 1
Lookup multiple cell values and place contents in a single cell 3
Adding or to previously provided Average If Array function 4
how do I use array references in VLOOKUP()? 2

Back
Top