How to write an IF formular or multiple conditions in an Excel

How to use IF where you have Cell J188:J655 has either Yes or No but I want the formular to return YES on the ''No"just after each YES not all the ''NO".

Thank you.