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

Blayne

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

SoS | Dan Palenchar

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)

SoS | Dan Palenchar

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)

Blayne

Perfect ....

Thank you!

Blayne