Hi there,

Can anyone please help me shorten this IF statement:

=IF((C29=S27),S7,IF((C29=R27),R7,IF((C29=Q27),Q7,I
F((C29=P27),P7,IF((C29=O27),O7,IF((C29=N27),N7,IF(
(C29=M27),M7,IF((C29=L27),L7,IF((C29=K27),K7,IF((C
29=J27),J7,IF((C29=I27),I7,IF((C29=H27),H7,IF((C29
=G27),G7,IF((C29=F27),F7,IF((C29=E27),E7,IF((C29=D
27),D7)))))))))))))))))

The reason why I need this shortening is because Excel says I can only
have 7 IF statements.

Many Thanks,




--
funkeycooldude

It looks like you could just use:
=INDEX(D7:S7,MATCH(C29,D27:S27,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"funkeycooldude" wrote in
message . ..

Hi there,

Can anyone please help me shorten this IF statement:

=IF((C29=S27),S7,IF((C29=R27),R7,IF((C29=Q27),Q7,I
F((C29=P27),P7,IF((C29=O27),O7,IF((C29=N27),N7,IF(
(C29=M27),M7,IF((C29=L27),L7,IF((C29=K27),K7,IF((C
29=J27),J7,IF((C29=I27),I7,IF((C29=H27),H7,IF((C29
=G27),G7,IF((C29=F27),F7,IF((C29=E27),E7,IF((C29=D
27),D7)))))))))))))))))

The reason why I need this shortening is because Excel says I can only
have 7 IF statements.

Many Thanks,




--
funkeycooldude

Try this:

=IF(COUNTIF(D27:S27,C29),INDEX(D7:S7,MATCH(C29,D27 :S27,0)),"")


--
Biff
Microsoft Excel MVP


"funkeycooldude" wrote in
message . ..

Hi there,

Can anyone please help me shorten this IF statement:

=IF((C29=S27),S7,IF((C29=R27),R7,IF((C29=Q27),Q7,I
F((C29=P27),P7,IF((C29=O27),O7,IF((C29=N27),N7,IF(
(C29=M27),M7,IF((C29=L27),L7,IF((C29=K27),K7,IF((C
29=J27),J7,IF((C29=I27),I7,IF((C29=H27),H7,IF((C29
=G27),G7,IF((C29=F27),F7,IF((C29=E27),E7,IF((C29=D
27),D7)))))))))))))))))

The reason why I need this shortening is because Excel says I can only
have 7 IF statements.

Many Thanks,




--
funkeycooldude