Excel file help IF Function-need today, the right person can do it quickly

Took me roughly 1.5 hours to do. was looking for a long term person for computers, but now I know why I quit this place long ago.