100% round down

[Helen Wills]

Hi

I have an audit matrix document which calculates %age scores for multiple sites. The score should always show a full number (i.e 80%, 90%, etc...), and I am happy for standard rounding to apply (i.e round down for .4 and below, round up for .5 and above)

However, I don't want this to apply for 99.5-99.5%. In this case ONLY, I would need it to round down to 99% as i can't award a perfect score to a site where something has dropped a point,

Can anyone help with this please?

Thanks x

 

[FormR]

Hi, how about something like this.

Excel 2013/2016
	A	B
1	%age	Rounded
2	10.12%	10%
3	90.30%	90%
4	99.25%	99%
5	99.50%	99%
6	99.99%	99%
7	100.00%	100%
Sheet1

Cell Formulas
Range	Formula
B2	=IF(A2>=99.5%,FLOOR(A2,1%),MROUND(A2,1%))