If Isblank on a range of cells

Hello, Excel Gurus:

Please help on this one!!

I have five columns of data. Some columns have data, some are empty.

Goal:
1. Create a new Column, with value "Yes" or Blank. And do checking.
2. For each row, check the five cells in those five columns, if any of the cells have value, then return "Yes", Else return Blank.

For Example,
"Mary", Blank, Blank, "Tom", Blank Result: "Yes"
Blank, Blank, Blank, Blank, Blank Result: Blank

My function:
IF(ISBLANK(F3:J3), ";", "Yes") "Yes" checking return correctly, However, if all cells are blank, it still return "Yes"

Please Help!!

Thank you!!

I just tried with your suggestion. Sorry, the checking when all five cells are blank, it still return "Yes".

Please help!!

Or try this ...

=IF(COUNTBLANK(F3:J3)=5,";","Yes")

Bingo Thank you so much guys!! You make it working!!

@MrShorty, you are correct. Thanks for your remind!! Those cells are NOT Truly Blank!! I guess. Once switch "", it works!!
If we remain as it is in the five columns, @Phuocam, your countblank formula also works!!