Is there an easier way than this If(AND)?

[Cease]

Hey, I'm sure there's a better way, but I cannot find the syntax.

My current formula goes a little like this:

=if(and(j14>1,j15>1,j16>1,j17>1,j18>1,j19>1),"Meets","DNQ")

I just can't seem to group them together right.

Thanks in advance for any advice/direction!

 

[barry houdini]

Try

=IF(COUNTIF(J14:J19,"<=1"),"DNQ","Meets")

 

[scottylad2]

Ctrl + Shift + Enter =IF(AND(J13:J19>1),"Meets","DNQ")

 

[Cease]

Rock on, that does it.

On another note (I could definitely be mistaken) I feel I've seen similar things with brackets that group a range or array that are to be set against the same criteria together. Any direction where I can find more info how those work out?

Thanks so much for a killer solution so fast. I really appreciate it!

 

[scottylad2]

Its called creating an Array Formula. They are quite efficient, but if you were checking a large range, as in thousands of items it can take a little longer to calculate. Essentially you are checking all your values to see if it meets one criteria, theres many other types as well where you might be checking if any value in an array meets criteria, or use to extract unique entries....too many uses to mention really.

A good place to study is this forum, use the search box and you'll see theres loads of other uses

 

[Cease]

Great to know, thanks Scottylad. I missed your first post, I guess I was writing my reply when you posted yours.

Yeah this forum is full of so much information, thanks to all you guys who know that help us newbies out as much as you do!

Thanks again and have a good one!

 

[Dryver14]

Cease,

This site has a really good explaination of SUMPRODUCT

http://www.xldynamic.com/source/xld.SUMPRODUCT.html