How to make the number in my string + formula display as a percent?

ECD Auto Design

I am having an issue where i have created a string plus a formula (="Percentage Complete " + COUNTIFS(Complete2:Complete11, =1) / 10 ) is there any way i can get the number that is being counted in my formula to read as a percent? i tried clicking the percent symbol while having the cell selected but since the string is attached to the number it isnt converting it

Paul Newcome

Try this...

="Percentage Complete " + ((COUNTIFS(Complete2:Complete11, =1) / 10) * 100) + "%"

Paul Newcome

Try this...

="Percentage Complete " + ((COUNTIFS(Complete2:Complete11, =1) / 10) * 100) + "%"

ECD Auto Design

Thank you, That worked

Paul Newcome

Happy to help. 👍️