lil help with "or" formula

[Murph]

I am trying to return a "false" value if there is text in cells E2:I2.. the
only formula i have come up with so far is
=OR(ISTEXT(E2),ISTEXT(F2),ISTEXT(G2),ISTEXT(H2),ISTEXT(I2))
but this returns the opposite value of what I want, it tells me "true" if
there is text...

any help????

 

[Frank Kabel]

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

 

[Murph]

returns an error... first about a missing parenthese and then once inserted
tells me the formula is invalid

 

[Murph]

Check that... i figured out the error.. Thanks for the help Frank

 

[Chip Pearson]

Murph,

Try
=IF(SUMPRODUCT(--(ISTEXT(E2:I2))),FALSE,TRUE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Frank Kabel]

Hi
sorry for that. Try:
=IF(SUMPRODUCT(--ISTEXT(E2:I2)),false,true)