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