Can't get a formula to show a percentage?

Unsolved

I'm brand new to sheets and was wondering how I could get the number to appear as a percentage instead of a decimal with the text beforehand. I am trying to get a percentage based on how many checkboxes have been checked and this formula displays the percentage without the text there. Current formula is ="EXAMPLE TEXT "&COUNTIF(C2:C, TRUE)/COUNTA(C2:C). Thanks for any help with this :)

https://preview.redd.it/cwmnuyuvblhe1.png?width=1022&format=png&auto=webp&s=d6fcfffcc0864193ea5f242a70ddbbe18d3881d9

Posted Feb 6, 2025, 10:00 PM UTC

15
Loading comments…