isblank or iftext????

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top