IF/AND/THEN Function

Question

Hi everyone :)

I'm attempting to create an IF/THEN formula to do the following:

IF U2, V2, W2, X2, Y2, Z2, AA2, AB2 are all <0, AND S2 isn't blank (it'll be filled with text not numbers), THEN "Comment", but if any of them are >0 then " "

So far I've done

=IF((AND(U2<0,V2<0,W2<0,X2<0,Y2<0,Z2<0,AA2<0,AB2<2)), "COMMENT", "")

Questions: how do I add the AND 'IF S2 isn't blank' portion? Also, the formula seems to work by staying blank if any of the cells are greater than 0, however; it isn't saying "COMMENT" when they aren't.  

Thank you!

Answer 1

=IF(AND(U2<0,V2<0,W2<0,X2<0,Y2<0,Z2<0,AA2<0,AB2<0,S2<>""), "COMMENT", "")

or

=IF(AND(COUNTIF(U2:AB2,">=0")=0,S2<>""), "COMMENT", "")

Answer 2

They both work perfectly. Thanks for your help!