Complex IF Formula with multiple

Hi, I am new to Excel and trying to complete what I would consider quite a complicated IF formula (if that is even the correct function to use here!)   An example of my Dataset:    A B C D ...