Multiple formulae in a cell but displaying the result

[Petepete11]

Hi there, I am after some help. What I am wanting to do is to have several formulae in one cell but for the cell to display the results. I don't mean just having a cell which contains several formulae that computes to 1 value. For example, I have a column of yes, no and not applicable answers for questions, so i want to display in a cell what the percentage of yes's is to the no's, taking into account the n/a's. So the cell to display for example '50% (1/2)' if there was 1 yes and 1 no, and 1 n/a. So to work out the number of yes's/no's/na's I can use countifs but want all the commands in one cell and displayed results as above. Hope someone can help. Many thanks, Pete

 

[dckmob]

easier than you realise:
=value1&" ("&value2&"/"&value3&")"
just replace value* with your seperate countif formula's

 

[Petepete11]

Thanks man! Just another question, how do i display value1 as a percentage? Cheers

 

[Jonmo1]

Try

=TEXT(value1,"0.0%")&" ("&value2&"/"&value3&")"

 

[Petepete11]

Hi, my spreadsheet says i have too many arguments :/

Essentially my data looks like this:
Column 1 category
A
B
B
D
B

Column 2 question answers
Y
N
ND
N
Y

So at the bottom of the spreadsheet I want the compliance with that question so the number of Y against the potential denominator, so i want it to display "40% (2/5)" for overall Question compliance, but also if i want to just look at the answers for 'B' (3) and give a compliance for that category i.e. "33% (1/3)".
Hope someone can help, many thanks, Pete