Question Locked

How many "OR" functions in an excel forumula?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by thumbsup2

There is not a limit on the OR function.

Try this

=IF(OR(ISTEXT(I2),ISTEXT(J2),ISTEXT(K2)),"Text exists","")

.
edited to add note:

If you click inside the formula bar, you will see color coding to match up your pairs of parrens. Watch the colors closely.

To make that formula more understandable, think of it like this:

=IF (
??OR (
????ISTEXT(I2),
????ISTEXT(J2),
????ISTEXT(K2)
??),
??"Text exists",
??""
)

------

This discussion is closed to new replies.