| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding percentages problem need a solution for
Boss wants total formula showing the percentages of each of our three
offices' transactions compared to the total of all three combined, in whole numbers, but sometimes the three percentages do not equal exactly 100%. Example: Office 1 total trans is 6074 Office 2 total trans is 7052 Office 3 total trans is 6105 Grand total for all three offices trans is 19231 Using formula that divides office 1 cell by grand total = 32% Office 2 = 37% Office 3 = 32% But 32% + 37% + 32% equals 101%! If I change the three percentage cells format to show two decimal places then it always equals 100%, but the boss wants whole numbers only, and wants it to equal 100%! My formula needs a fix! Thank-you for your time!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Pasting Data | Setting up and Configuration of Excel | |||
| strange problem with links updates in excel | Excel Discussion (Misc queries) | |||
| Rounding off problem..! | Excel Worksheet Functions | |||
| problem office assistant | Excel Discussion (Misc queries) | |||
| Macro Solution for Link Problem? | Excel Worksheet Functions | |||
Threaded Mode
