Is there a way to shorten the OR part of the below function?
Formula:Please Login or Register to view this content.
Or, is there an easier way altogether to achieve the same result?
Is there a way to shorten the OR part of the below function?
Formula:Please Login or Register to view this content.
Or, is there an easier way altogether to achieve the same result?
Perhaps this
=IF(SUMPRODUCT(COUNTIF($BM$3:$BS$11,C14:K14))=0,"X","Y")
Don
Please remember to mark your thread 'Solved' when appropriate.
That does what I want. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks