Formatting number to percent in a formula ?

[PCRIDE]

I have a shape, and within the shape there is a formula that points to another cell. SO the cell just refers to another cell. In the cell it references I have a IF statement with text combined with another cell reference. Everything works great except the number format is coming through as a decimal not % . Any idea how to force the format? I know sometimes when combining formulas and text it doesn't always work well.

If(A1=1,"Your cell is greater than"&" "&B35)

B35 would be a number formatted as a percent.

 

[Rick Rothstein]

I have a shape, and within the shape there is a formula that points to another cell. SO the cell just refers to another cell. In the cell it references I have a IF statement with text combined with another cell reference. Everything works great except the number format is coming through as a decimal not % . Any idea how to force the format? I know sometimes when combining formulas and text it doesn't always work well.

If(A1=1,"Your cell is greater than"&" "&TEXT(B35,"0.0%"))

B35 would be a number formatted as a percent.

Try as shown in red above (adjust the number of decimal places to match your desired output). Note that you might want to provide an output for when A1=1 is false.

 

[PCRIDE]

Thanks Rick, it worked perfectly! I've always wondered how to make that work.