Thread
:
Adding Text to Answer
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
Posts: 5,651
Adding Text to Answer
On Fri, 19 Oct 2007 17:46:15 -0000,
wrote:
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)
If you want to maintain the result as a number, you could use custom
formatting:
Format/Cells/Number/Custom Type:
"Team A by "0;"Team B By "0;"Draw"
If the result is greater than 0, then Team A is ahead; if less than 0, then
Team B is ahead; and if equal 0, the cell will show "Draw"
--ron
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld