Merging three columns of data

[Airlea]

Hi everyone:

I've run into a roadblock in regards to a formula. I'm trying to create the following:

excel..png

To look like: (89%) 87/98

Currently, the 89% is a calculation of A/B.

I've managed to get SOME of the formula but I'm currently staring at a blank wall..... ="(C6) "&" ("&B6&"/"&C6&")"

which results in: (c6) 87/98

So... Almost there!!! What am I doing wrong?

Sincerely,
Airlea

[alansidman]

Try this: =C6 &" ("&B6&"/"&C6&")"

[Jonmo1]

Try

="("&TEXT(C6,"0%")&") "&A6&"/"&B6

[etaf]

try

="(" & C6*100 & "%) "&" (" & B6 & "/" & C6 & ")"

[Airlea]

Wow you guys... thanks for the quick response... I was going blind trying to figure it out!! I went with this one... ="("&TEXT(C6,"0%")&") "&A6&"/"&B6

again, thank you SO much. You've made my day <3

[Jonmo1]

You're welcome.