For full details about nested IF's syntax and logic, please see Excel nested IF - multiple conditions in a single formula.
Lookup formulaIf you are looking for a more compact and better understandable formula, use the LOOKUP function with lookup and return values supplied as vertical array constants: