How do i make a percentage round up / round down

[deborahservices]

I have 5 ivalues that all are changed to a percentage, when the 5 values are added up they equal 101

but if you put the 5 values in a calculator, would add up to 100, this is because excel is giving an exact percentage of 5 different values.

E.G

25
25
25
25

= 100

but excel is hiding the final digits

25.2
25.6
25.0
25.2

How do i get a percentage that is rounded down/up (down would be better)

 

[MarkAndrews]

Hello & Welcome to the board

You can use this formula

=ROUNDDOWN(N7,0)