treat for excel geeks

[Smart Actuary]

solve my problem and make your day:

i have 3 rows of numbers.

if all numbers in a column have same sign, i want to flag it 1, if 2 have same sign flag 2.

write me a formula to do that.

your welcome?

[vividox]

=IF(OR(AND(A1>0,A2>0,A3>0),AND(A1<0,A2<0,A3<0)),1, 2)

Put that in the fourth row and drag across the row.

[ADoubleDot]

IF(OR(SUMPRODUCT(--(A2:C2>0))=0,SUMPRODUCT(--(A2:C2>0))=3),1,2)

[V1per41]

Little verbose:

=IF(A1<0,IF(A2<0,IF(A3<0,1,2),2),IF(A2>0,IF(A3>0,1 ,2),2))

Not sure what you wanted to do if they equal zero

[ADoubleDot]

damn, too slow. mine is more better though

spent too long trying to figure out how to do it without the OR.

[V1per41]

Originally Posted by ADoubleDot

damn, too slow. mine is more better though

spent too long trying to figure out how to do it without the OR.

When I plug yours in, I got 2 for all of them.

ETA: NM, you did A1-C1 as the range instead of A1-A3

[stilts3]

=IF(COUNTIF(A1:A3,">=0")*COUNTIF(A1:A3,"<0")=0,1,2 )

[Smart Actuary]

i used vivi's but also want to see how adoubledots' work. be back with report.

Thanks guys.

[ADoubleDot]

oh, i did it for columns of numbers instead of rows

fixed: IF(OR(SUMPRODUCT(--(B1:B3>0))=0,SUMPRODUCT(--(B1:B3>0))=3),1,2)

[Baby, ByeBye]

drones