How many "OR" functions in an excel forumula? - TechRepublic
Question
January 29, 2009 at 12:22 PM
jon at work

How many “OR” functions in an excel forumula?

by jon at work . Updated 17 years, 5 months ago

I would like to write a value that looks at several cells to determine if there is text in them. The forumla I’m writing works for two of the cells:

=IF(OR(ISTEXT(I2),(ISTEXT(J2))),”Text exists”,””)

But, how do I write this to add a third cell (K2 for example).

I’m getting errors, so I’m wondering if using OR is limited to looking at two cells.

Can anyone suggest perhaps a better approach?

Thanks,

Jon

This discussion is locked

All Comments