isblank or iftext????

[Guest]

I'm trying to set up a formula that will give me a true false if there is any
text in a row of cells. I used "isblank" but it would only work on individual
cells and not the entire 5 cells in the row. I tried "istext"
unsuccessfully.. any help.
I want to return a value of "false" if there is text in the cells and "true"
if there is no text.

ie... cells E2:I2 are blank.. I want to have a cell that says "true".. vice
versa if there is text.
Thanks for the help

 

[Frank Kabel]

Hi
one way:
=IF(SUMPRODUCT(--(ISTEXT(E2:I2)),false,true)