different formula for ROW, array / range?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))
 
Back
Top