IF ranges for multiple columns greater then less then

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
 
B

Bob Phillips

What happens if D31 <= 9?

--

HTH

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

Soccer_Ref

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.
 
D

Domenic

Try...

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

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top