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)
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)