"CLR" wrote...
Well then..........maybe this.......

=IF(OR(ISTEXT(BN23),ISTEXT(BO23),ISTEXT(BP23),IST EXT(BQ23),ISTEXT(BX23)),""
,
PutYourFormulaHere)

This works.

or this

=IF(COUNTA(BN23:BQ23,BX23)COUNT(BN23:BQ23,BX23), "",PutYourFormulaHere)
....

This may not work if the OP wants to exclude cells containing boolean or
error values, which aren't text but would be counted by COUNTA. For that
matter, it fails when all cells are blank.

Try

=IF(COUNTIF(BN23:BQ23,"*")+ISTEXT(BX23)=5,PutYourF ormulaHere,"")