Large Nesting Problem

[breakr19]

I'm looking to combine the following formulas into one cell. I would nest them, but I can't even get that to work correctly for two of them, let alone all six. There has to be a simpler way that I am just not knowledgeable about.

IF(AND($F52>$K52,$D52<$I52),16-ABS($D52-$I52))

IF(AND($F52>$K52,$D52>$I52),16+ABS($D52-$I52))

IF(AND($F52<$K52,$D52<$I52),16+ABS($D52-$I52))

IF(AND($F52<$K52,$D52>$I52),16-ABS($D52-$I52))

IF(AND($F52>$K52,$D52=$I52),16)

IF(AND($F52<$K52,$D52=$I52),16)

 

[shg]

Formulas 5 and 6 are redundant to the first 4.

What if F52=K52?

 

[p45cal]

This is getting close:
=16+($I52-$D52)*IF(F52>K52,-1,1)
it just doesn't return FALSE when F and K are equal.

 

[breakr19]

shg is right on the redundancy of 5 and 6.

F52 will never = K52 due to the fact that they are head-to-head competitions, and the end result will always have one higher than the other.



p45cal, your formula works exactly like I need it to. It's crazy how much more simplified and clean that is compared to the listing (and possible nesting) of the other four. Thank you!