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

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