Concatenate

[PAL]

I am using the following formula:

=CONCATENATE(Sheet1!B2,"(",Sheet1!B15,")")

The reference cell, "Sheet1!B15", is formatted as a percentage. The output
that I get from this formula is:

"4(0.0615384615384615)"

How do I get the "0.06..." to come out as 6% so it looks like this:

"4(6%)"

Thanks.

 

[Gary''s Student]

=CONCATENATE(Sheet1!B2,"(",TEXT(Sheet1!B15,"0%"),")")

 

[Rick Rothstein]

A little more compact...

=Sheet1!B2&TEXT(Sheet1!B15,"(0%)")