different formula for ROW, array / range?
 

hi, trying to see if way to cut down on couple columns, have:

=IF(AND(ROW(A9)$T$2,ROW(A9)<$T$3),0,1)

pending a second column or 2nd copy of variable within same formula:

=IF(OR(AND(ROW(A9)$T$2,ROW(A9)<$T$3)
AND(ROW(A9)$U$2,ROW(A9)<$U$3)),0,1)

Is there a shorter way to accomplish using a range, values in $T$2 & $T$3
which might say something like: =ROW($A$227) & =ROW($A$355)
note: would rather keep these values as external controls. thanks


=IF(ROW(A$227:A$355),0,1) does not quite seem to work

different formula for ROW, array / range?
 

alternate idea, but rather have shorter, answer would be:
=IF(AND(ROW($A9)$T$2,ROW($A9)<$T$3),0,IF(AND(ROW( $A9)$T$4,ROW($A9)<$T$5),1,2))

"nastech" wrote:

hi, trying to see if way to cut down on couple columns, have:

=IF(AND(ROW(A9)$T$2,ROW(A9)<$T$3),0,1)

pending a second column or 2nd copy of variable within same formula:

=IF(OR(AND(ROW(A9)$T$2,ROW(A9)<$T$3)
AND(ROW(A9)$U$2,ROW(A9)<$U$3)),0,1)

Is there a shorter way to accomplish using a range, values in $T$2 & $T$3
which might say something like: =ROW($A$227) & =ROW($A$355)
note: would rather keep these values as external controls. thanks


=IF(ROW(A$227:A$355),0,1) does not quite seem to work