CONCATENATE & Percentages

[H7H12]

Hi there,

I wish to concatenate a integer and text in one cell.

I wish to convert the integer into a percentage and round it down to 2 decimal places. Here is my current formula:

=CONCATENATE(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100)," % and text")

However, I am left with a number with 10+ decimal places, for example:

332.54545454545

Is there a rule I can apply within the brackets to remove these extra decimal places? Ideally I want to stick with concatenation, as it is very helpful for my project.

I am using Office 2007, Windows XP.

 

[MisterBates]

use

=CONCATENATE(round(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100),2)" % and text")

 

[H7H12]

use

=CONCATENATE(round(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100),2)" % and text")

That works perfectly - thank you!