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!