COUNTIFS formula with a percentage but I need it to round up


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?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!