|You might be able to use a formula known as a Nested IF. If you DAGS for Nested IF you'll get lots of hits, both text based and videos.|
In your case, it might look something like this:
Depending on how many conditions you have this could get quite cumbersome. Perhaps with some more details we could offer an alternative method.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.