IF Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

funkeycooldude - 24 Mar 2008 00:33 GMT

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,

Signature

funkeycooldude

Reply to this Message

Max - 24 Mar 2008 03:32 GMT

It looks like you could just use:
=INDEX(D7:S7,MATCH(C29,D27:S27,0))

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>
> Hi there,
[quoted text clipped - 12 lines]
>
> Many Thanks,

Reply to this Message

T. Valko - 24 Mar 2008 03:32 GMT

Try this:

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

Signature

Biff
Microsoft Excel MVP

> Hi there,
>
[quoted text clipped - 11 lines]
>
> Many Thanks,

Reply to this Message