Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In my spreadsheet I have 6 cells that always sum to equal 100%. I am having
troubles showing the values as whole numbers that will always will equal 100%. For example I ran into the following problem: 50.585% 48.903% 00.512% 00.000% 00.000% 00.000% total = 100% My spreadsheet shows: 51% 49% 1% 0% 0% 0% Total equals 101% How do I get it to show: 51% 49% 0% 0% 0% 0% Total Equals 100% Thanks, Curt J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rounding question | Excel Discussion (Misc queries) | |||
Rounding Question | Excel Discussion (Misc queries) | |||
Rounding Question | Excel Worksheet Functions | |||
Rounding Question | Excel Worksheet Functions | |||
rounding question | Excel Discussion (Misc queries) |