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)
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
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)
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
-
Perfect ....
Thank you!
Blayne
Help Article Resources
Categories
Check out the Formula Handbook template!