| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula is text, not resolving to an answer | Excel Discussion (Misc queries) | |||
| Adding Dashes in front of text using text formating | Excel Discussion (Misc queries) | |||
| Bob phillipps answer for counting text | Excel Discussion (Misc queries) | |||
| Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
| If result is...Then text is the answer | Excel Discussion (Misc queries) | |||
Threaded Mode
