Excel logical_test

**gtd627** · 08-20-2012, 03:30 PM

If any one can help I will be great appreciative. I have an IF formula. In my logical_test I am using not just one cell but 70 cells in the same colum. I can list each one with OR, but is there a quick list of not having to list each one possibly like a SUM?
Thank you.

**Søren Larsen** · 08-20-2012, 03:34 PM

What are you trying to achieve with your formula?

**daddylonglegs** · 08-20-2012, 03:35 PM

What's the criteria?

If you want to trigger the TRUE value if the range contains any "x" value, for example, try this

=IF(COUNTIF(range,"x")>0,TRUE,FALSE)

**tigeravatar** · 08-20-2012, 03:35 PM

gtd627,

Welcome to the forum!
It sounds like you're comparing 70 cells to the same logical test. If that is the case, you'll need to array-enter your formula with Ctrl+Shift+Enter and not just Enter. However, depending on what you want your formula to do, there may be a better option, such as Sumproduct, Sumif, Sumifs, Countif, Countifs, Index/Match, or more.

**gtd627** · 08-21-2012, 09:46 PM

Thank you, everyone.
I used what everyone suggested and came out with =IF(COUNTIF(N$4:N$63,"Beth")," ","Beth")
which is what I was looking. Thanks again.

**Cutter** · 08-21-2012, 11:04 PM

@ gtd627

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.