S
Soccer_Ref
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(D31>9,IF(D31<28,E31,IF(F31>9,IF(F31<28,G31,IF(H31>9,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
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(D31>9,IF(D31<28,E31,IF(F31>9,IF(F31<28,G31,IF(H31>9,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