How do I subtract in either direction?

[dlvgolf]

Here is what I tried:
=IF(SUM(A5)<A5,=(A5-A5),IF(SUM(A5)=A5,"0",IF(SUM(A5)>A5,=)A5-A5))))

But, even if I could get that to work, it wouldn't show me if the result was for the Blue or Green Team

Column A = Blue Team; Column B = Green Team
Cell A5 = 1; Cell B5 = 2
Cell C5 needs to show "G1" (Green Team wins by 1)
or if
Cell A5 = 3; Cell B5 = 1
Cell C5 would need to show "B2" (Blue Team wins by 2)

then

in another cell add the number result from above (Cell C5) to a number in a completely different cell (Cell D15).


Thanks again for all your help.

Green Team Blue Team
- 1 - Whib / Ski Craig / Hugo
Front -1 +2 G+2
Back +2 +1 B+2
Birdies 2 3 (1)

 

[Andrew Poulsom]

Say A1 and B1 contain Blue and Green respectively. In C5:

=LEFT(INDEX(A$1:B$1,,MATCH(MAX(A5:B5),A5:B5,0)))&ABS(A5-B5)

 

[West Man]

Or possibly in C5:
=IF(B5>A5,"G"&TEXT(B5-A5,"#"),IF(A5>B5,"B"&TEXT(A5-B5,"#"),"Tie"))

 

[dlvgolf]

Just a little more help please...

What would I use in Cell D15 to add the results from the above number to another cell?

Thanks again for your help.

 

[Andrew Poulsom]

This will add the numeric part of C5 to what's in D1.

=SUM(MID(C5,2,255),D1)

 

[dlvgolf]

Thanks very much for all your help