IF/AND statement with a Countif included
Hello
I need a formula that can validate a cells contents and also do a count in a range to show me if that range is empty. What is the easiest way?
=if(and((A2="TT",Countif(a5:A8,0),"YES,""))) ....this obviously doesn't work but it is what I am trying to accomplish.
Thanks in advance for any help on how to achieve this
|