I am trying to combine 2 IFs statement together to get 1 IF.

The reason I need 2 IFs is cos excel only allows a max number of nested IFs in one cell.

Does anyone know the solution? Or is there a better way of doing it?