IF statement with multiple "layers"

[dexnmav]

Hi, this is my first post, so hopefully I'm asking everything correctly.

I'd like the result column to be either P, R, or SCO based on the wrong and errors columns.

I'd like to know:
IF wrong =< 15 AND errors=0, then result is P
AND
IF wrong =<10 AND errors=1, then result is SCO
AND
IF wrong >15 OR errors >1, then result is R

Wrong	Errors	Result (P/SCO/R)
6	0
12	1
4	1
5	2

<tbody>
</tbody>

I've tried several different formulas just to get the first part of the equation to work so I can have a base to complete the rest, but something isn't working right for me.

Thanks in advance for your help! I greatly appreciate it!

 

[dexnmav]

No, that did not work.

 

[dexnmav]

My mistake, got one sign wrong =) its like this:
=IF(AND(A2<=15, B2=0), "P",IF(AND(A2<=10, B2=1), "SCO", IF(OR(A2>15, B2>1), "R", "OTHER")))

I figured it out! Thank you for your help. The problem was with the "wrong" column. The person that created the spreadsheet didn't have a formula in that column that worked with the numbers I was inputting; they were using literal percentages, so .019 instead of 2. Once I changed their formula and used yours, viola!