IF Formula Modification.

I am currently using the following formula to provide either a "A" or a "B" in column M10 based on the numbers in I10, J10, K10. If I10+J10-K10 is less then "0" then M10 ="A". If I10+J10-K10 is greater than "0" then M10 ="B".

=IF(OR(AND(I10=0,J10=0,K10=0),COUNT(I10:K10)<3),"",IF(I10+J10-K10<0,"A","B"))

I now need to add a third possibility: if I10+J10-K10 ="0" then M10 ="C".

Try

=IF(OR(AND(I10=0,J10=0,K10=0),COUNT(I10:K10)<3),"",CHOOSE(SIGN(I10+J10-K10)+2,"A","C","B"))

Works perfect. You guys always deliver. Many Thanks as always.

You're welcome.