IF statement with several conditions

Hi all, thank you for your kind replies!! I managed to get the results using the formula below after several attempts :) 

Formula: