display results

[jmazorra]

hello

I am trying to divide H21/h22 on cell i22 and have the result display in i22 as:

example: 7% of wages.

thx

 

[CWatts]

=ROUND(H21/H22*100,0)&"% of wages"

 

[jmazorra]

Thank you:

I am trying to have cell E8 display the following: 15 or 12% of the total

At the moment I have the following statement on cell E8: =COUNTIF(K6:K127,"=y"). This gives me the count I want (15), but I also want to know what percentage that count is of the total number which is found on E7. So the second formula would be E7/E8, this gives me 22%.

I am now using 3 cells to come up with a result stating: 15 or 22% of the total. How can I combine all formulas so that the statement :"15 or 12% of the total" is calculated and displayed on cell E8

Thanks

 

[CWatts]

Here are several variations, with the only change being the display of the percentage.

=COUNTIF(K6:K127,"=y")&" or "&TEXT(COUNTIF(K6:K127,"=y")/COUNTA(K6:K127),"0%")&" of the total"

=COUNTIF(K6:K127,"=y")&" or "&TEXT(COUNTIF(K6:K127,"=y")/COUNTA(K6:K127),"0.00%")&" of the total"

 

[jmazorra]

It worked perfect,