Percent calculation

[JohnJP]

I know i can do this in multiple cells, but I would like it all to be in one cell.

e.g. - 236/329 (72%)

Just like shown above.

Thanks for your help.

John

 

[dave3009]

Hi John,

Do you mean you want to show the actual values of the division in the cell plus the result? Maybe a wee snippet of before and after might help

Thanks

Dave

 

[JohnJP]

Dave,
Thanks, after I posted I realized it wasn't exactly clear. Yes, that is it, I want to show the values and the result. The values change weekly which I enter manually. I need to have the percent calc'd and displayed. I have been getting the percent manually, but I knew there had to be a way to provide a formula for it.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][TABLE="width: 151"]
<tbody>[TR]
[TD="class: xl65, width: 151"]236/329 (72%)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 151"]
<tbody>[TR]
[TD="class: xl65, width: 151"]240/329 (73%)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks!
John

 

[dave3009]

Hi John

Still a slight bit unsure exactly what you're trying to achieve. You can apply a format to the cell to return a percentage after dividing, or format as fraction but to do both and get all in the one cell as you have displayed you'd need to do the calculation twice in the same cell

Here are a few ideas, are we getting close?

Excel 2007
	B	C	D	E	F
13	Input 1	Input 2	Format %age	Format Fraction	Result??
14	239	326	73%	239/326	239/326 (73%)
Sheet1

Cell Formulas
Range	Formula
D14	=B14/C14
E14	=B14/C14
F14	=TEXT(B14/C14, "???/???")&" ("&TEXT(B14/C14, "0%")&")"

Regards

Dave

 

[jtakw]

Hi,

Another way:

Excel 2010
	A	B	C	D
1	236/329			236/329 (72%)
2	236	329		236/329 (72%)
Sheet1

Cell Formulas
Range	Formula
D1	=A1&" ("&ROUND(236/329,2)*100&"%)"
D2	=A2&"/"&B2&" ("&ROUND(A2/B2,2)*100&"%)"

 

[JohnJP]

Dave,
Thanks for your help. That is what I am trying to do. Client want s to see it that way.

btw, my wife's grandmother was from Dumbartonshire, McNaughton.

 

[JohnJP]

Thanks jtakw, that is how I need to display it due to client requirement.

 

[jtakw]

You're welcome, welcome to the forum, glad we can help.