Round a number in percentage into a text with a formula in an excel report

One of the things I like to do in my reports, it is to create a simple and small automatic resume that I can put in my charts. This resume normally is always the same, only the number is changing, for instance, “today, we have 90% of incidents”. It means that the cell is a mix of text and formula then from my chart, I just do a simple cell reference.

formula excel


When I use the formula ?

When I want to put a default comment in my chart in an automatic, simple and quick way.


How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".


How are the formulas ?




I will explain only the “round” option because all work the same way. The only difference is that the “round” will do automatically the round up or down so if I want to force the round down, I use “rounddown”.

="Today, we have "&ROUND(A2/B2*100,0)&"% of incidents"

formula excel

Explanation (row 5):

  • A2/B2*100 is to calculate in percentage
  • 0 is to tell how many decimal numbers I want to show so if I want to show 71.4, I will put 1 so I will have this way “A2/B2*100,1” (row 6)

And in my chart, doing a reference to the sentence cell, a good way to create a quick resume that will be updated automatically.

As you can see in the picture below, putting:

="Today, we have "&C2

I don’t get the correct result I want (row 4).

formula excel

Interesting Management