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