View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] derr04@gmail.com is offline
external usenet poster
 
Posts: 13
Default Adding Text to Answer

First of all let me start by saying im not even sure if this is
possible but...

Is there a way that if i have two teams and team a has a total of 30
runs and team b has a total of 14 runs...i want to compare the two
i.e. 30-14 but instead of the answer just coming out 16, i want it to
come out as Team A by 16.....so that way if it was the other way
around instead of just giving me a -16 it would say Team B by 16

Team A total is in cell F5 and Team B total is in cell G5...so a
normal formula would be a simple (f5-g5)