Two formulas in one cell giving two results, possible?

**OBigO** · 03-02-2016, 03:01 PM

Hi! I am wondering if this is possible...I have used the countif function to count data from a selected range, I then would like to show that value as a percentage next to that number in brackets.

I am counting the number of pole positions during a season which will give an absolute number. I then want to divide this number by the number of starts and have this show in brackets in the same cell. Is this possible or should I just create a new column and call it pole %?

Thanks!

**FDibbins** · 03-02-2016, 03:07 PM

Create both formulas, then just join them together...

=COUNTIF()&" "&yourotherformula

=SUM(A1:A10)&" (with "&"countif(A1:A10,A1)&" starts)"

**CAntosh** · 03-02-2016, 03:09 PM

If you plan to manipulate the resulting data at all, you'd be much smarter to use two columns. If you really want them both in one cell, it's not necessarily impossible, but more information (ideally a sample workbook) would help.

**MrShorty** · 03-02-2016, 03:10 PM

Is this possible or should I just create a new column and call it pole %?

Yes, it is possible, but, IMO, you should keep them in separate cells. I find that a spreadsheet is much easier to work with when each cell contains only one piece of information.

If it was very important to me to combine the two pieces of information, it would look like this:

Please Login or Register  to view this content.

Using the helper columns like that, I still have easy access to each individual piece of information, as well as the concatenated text string with both pieces of information that I can use for display purposes.

**OBigO** · 03-02-2016, 03:54 PM

Thanks for the quick replies! I have decided to create a new column and align it to the left so that they will appear to be in the same cell. How do I make it so that all the data in this new column is displayed in brackets, preferable with a % next to the number?

Thanks again!