If then statement?

[JTL9161]

I am looking for a IF statement that will:

In cell A9;Compare Cell D9 with K9 and show the greater number in cell A9
BUT
If D9 & K9 equal each other then compare E9 with L9 with the greater number showing in A9
BUT
If E9 & L9 equal each other then compare F9 & M9 with the greater number showing in A9
IF all 3 numbers equal each other then I need a 0 in cell A9.

Thanks for your assistance
James

 

[Fluff]

How about
=MAX(D91,K91)

Although it depends on the BUT

 

[Scott Huish]

=if(sumproduct(--(d9:f9=k9:m9))=3,0,max(lookup(2,1/(k9:m9-d9:f9<>0),d9:f9),lookup(2,1/(k9:m9-d9:f9<>0),k9:m9)))

 

[DanteAmor]

Try

=IF(D9<>K9,MAX(D9,K9),IF(E9<>L9,MAX(E9,L9),IF(F9<>M9,MAX(F9,M9),0)))

Or

=IF(D9=K9,IF(E9=L9,IF(F9=M9,0,MAX(F9,M9)),MAX(E9,L9)),MAX(D9,K9))