I have 12 columns of data. I need to create if commands that if the data on
column 1 is between a certain range to transfer the amount, if not, try the
next column, for six columns.
sample data
D E F G H I J K L
M N O
88 2.4928 10 0.1320 34 2.1868 70 3.0765 06 0.7635
98 1.1165 20 0.0290 62 0.3520 44 0.7791 80 1.5846 06 0.1670
working formula but only looks at half the range

=+IF(D319,IF(D31<28,E31,IF(F319,IF(F31<28,G31,IF (H319,IF(H31<28,I31,0))))))
I have gotten this far and it works, but the IF Function only allows 100
caracters and I would fall short. I need some other alternative to get the
same job done.

Thanks
--
Thanks, Eric

What happens if D31 <= 9?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Soccer_Ref" wrote in message
...
I have 12 columns of data. I need to create if commands that if the data
on
column 1 is between a certain range to transfer the amount, if not, try
the
next column, for six columns.
sample data
D E F G H I J K L
M N O
88 2.4928 10 0.1320 34 2.1868 70 3.0765 06 0.7635
98 1.1165 20 0.0290 62 0.3520 44 0.7791 80 1.5846 06 0.1670
working formula but only looks at half the range


=+IF(D319,IF(D31<28,E31,IF(F319,IF(F31<28,G31,IF (H319,IF(H31<28,I31,0))))
))
I have gotten this far and it works, but the IF Function only allows 100
caracters and I would fall short. I need some other alternative to get
the
same job done.

Thanks
--
Thanks, Eric

I basicly have set ranges if D31 (greater then) 9 and < (less then) 28 or
between the range of 10 thru 27. I need to see if columns "D" "F" "H" "J" "L"
& "N" fall into that range if yes, bring over the value of the next cell. If
false, give a 0 value.
--
Thanks, Eric


"Bob Phillips" wrote:

What happens if D31 <= 9?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Soccer_Ref" wrote in message
...
I have 12 columns of data. I need to create if commands that if the data
on
column 1 is between a certain range to transfer the amount, if not, try
the
next column, for six columns.
sample data
D E F G H I J K L
M N O
88 2.4928 10 0.1320 34 2.1868 70 3.0765 06 0.7635
98 1.1165 20 0.0290 62 0.3520 44 0.7791 80 1.5846 06 0.1670
working formula but only looks at half the range


=+IF(D319,IF(D31<28,E31,IF(F319,IF(F31<28,G31,IF (H319,IF(H31<28,I31,0))))
))
I have gotten this far and it works, but the IF Function only allows 100
caracters and I would fall short. I need some other alternative to get
the
same job done.

Thanks
--
Thanks, Eric

Try...

=SUMPRODUCT(--(MOD(COLUMN(D31:N31)-COLUMN(D31),2)=0),--(D31:N31+09),--(D
31:N31+0<28),E31:O31)

Hope this helps!

In article ,
"Soccer_Ref" wrote:

I have 12 columns of data. I need to create if commands that if the data on
column 1 is between a certain range to transfer the amount, if not, try the
next column, for six columns.
sample data
D E F G H I J K L
M N O
88 2.4928 10 0.1320 34 2.1868 70 3.0765 06 0.7635
98 1.1165 20 0.0290 62 0.3520 44 0.7791 80 1.5846 06 0.1670
working formula but only looks at half the range

=+IF(D319,IF(D31<28,E31,IF(F319,IF(F31<28,G31,IF (H319,IF(H31<28,I31,0))))))

I have gotten this far and it works, but the IF Function only allows 100
caracters and I would fall short. I need some other alternative to get the
same job done.

Thanks