Combined conditional logic with ISBLANK function

[ToadinHole]

I am trying to build a function that gives one of two text outputs in one column (W). I want columns K-U to return “Placement Info” if any of the cells are not blank. I also want the same formula to return the same “Placement Info” response but only if columns J AND I are not blank. Otherwise “No placement info”. I have the K:U portion working, but I am struggling to attach the second part, the AND statement. I would really appreciate any help.

=IF(and(ISBLANK(K2:U2))," No Placement Information", IF(SUM(K2:U2)=0,"No Placement Info", "Placement Information"))

 

[Joe4]

Welcome to the Board!

I am pretty sure that ISBLANK is only set up to work on a single cell.
Try using COUNTBLANK instead, to count the number of blanks cells.