How do i make a percentage round up / round down

deborahservices

New Member
Joined
Oct 18, 2006
Messages
1
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)
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Hello & Welcome to the board :biggrin:

You can use this formula

=ROUNDDOWN(N7,0)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,726
Members
410,702
Latest member
clizama18
Top