COUNTIFS formula with a percentage but I need it to round up
Hi
I am using this formula =COUNTIF({DA Audit Tracker Range 1}, "Y") / 273 * 100 + "" + "%"
It is giving me the right % answer which in this case at the moment is 67.76557%. But I just want it to round up to two decimal places ..... how do I do that?
Thanks
Blayne
Best Answer
-
Nest your formula within the ROUND function
=ROUND(COUNTIF({DA Audit Tracker Range 1}, "Y") / 273 * 100, 2) + "" + "%"
Though I'd recommend formatting your column as a percent and removing the *100 and percent symbol, leaving
=ROUND(COUNTIF({DA Audit Tracker Range 1}, "Y") / 273, 2)
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Answers
-
Nest your formula within the ROUND function
=ROUND(COUNTIF({DA Audit Tracker Range 1}, "Y") / 273 * 100, 2) + "" + "%"
Though I'd recommend formatting your column as a percent and removing the *100 and percent symbol, leaving
=ROUND(COUNTIF({DA Audit Tracker Range 1}, "Y") / 273, 2)
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Perfect ....
Thank you!
Blayne
Help Article Resources
Categories
Check out the Formula Handbook template!