Writing an IF statement in Excel 1

[Excelerate2004]

How can I write this in excel?

IF (C2>D2 AND C2>E2 AND C2>F2) Then "A"
ELSEIF (D2>C2 AND D2>E2 AND D2>F2)Then "T"
ELSEIF (E2>C2 AND E2>D2 AND E2>F2) Then "G"
ELSEIF (F2>C2 AND F2>D2 AND F2>E2) Then "C"
END IF

I keep getting caught up on the brackets!!

 

[AnotherHiggins]

The syntax works like this:

[COLOR=blue white]=if(and(C2>D2, C2>E2, C2>F2),"A",if(and(D2>C2, D2>E2, D2>F2), "T", if(and(E2>C2, E2>D2, E2>F2), "G", if(and(F2>C2, F2>D2, F2>E2),"C"))))[/color]

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[bluedragon2]

=IF(AND(C2>D2,C2>E2,C2>F2),"A",AND(D2>C2,D2>E2,D2>F2),"T",AND(E2>C2,E2>D2,E2>F2),"G",AND(F2>C2,F2>D2,F2>E2),"C","")

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

Forgot the additional IF's:

=IF(AND(C2>D2,C2>E2,C2>F2),"A",IF(AND(D2>C2,D2>E2,D2>F2),"T",IF(AND(E2>C2,E2>D2,E2>F2),"G",IF(AND(F2>C2,F2>D2,F2>E2),"C",""))))

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[AnotherHiggins]

You could drop the ANDs and make it a little more compact:

=IF(MAX(C2:F2)=C2,"A",IF(MAX(C2:F2)=D2,"T",IF(MAX(C2:F2)=E2,"G",IF(MAX(C2:F2)=F2,"C"))))

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[AnotherHiggins]

Forgot the additional IF's

When I read your first post, I thought I was about to learn something new.

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[Excelerate2004]

Thanks guys!

 

[AnotherHiggins]

Glad to help.


[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.