Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage according to Weightage
I have the below table where Weightage is nuber of bookings a person can
action in one hour. '17' is the total that has been actioned in 8 hours. I need to insert a formula where it shows what percentage of 8 hours has been has been utilised to action booking of each country so that the total percentage will be 100% Bookings Weightage Percentage 4 7.8125 2 5 0 13.75 0 13.75 9 20 2 5 0 18 0 37.5 0 7.8125 17 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage according to Weightage
As always, showing an example will help you get a solution much quicker.
What answer do you expect with the sample data you have given? You say 'percentage of 8 hours' but you don't show where the hours are. If there is supposed to be one row per hour, there are 9 rows in your sample. Also, how can there be weightage with no bookings? As a general guide, percentage of total is always amount divided by total, formatted as a percent. If you want what percent 4 is of the total of 17, it's 4/17 -- format as a percent to the number of decimals you prefer. The formula would be something like =a2/a$10. Regards, Fred. "Kash" wrote in message ... I have the below table where Weightage is nuber of bookings a person can action in one hour. '17' is the total that has been actioned in 8 hours. I need to insert a formula where it shows what percentage of 8 hours has been has been utilised to action booking of each country so that the total percentage will be 100% Bookings Weightage Percentage 4 7.8125 2 5 0 13.75 0 13.75 9 20 2 5 0 18 0 37.5 0 7.8125 17 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage according to Weightage
Preferred outcome is
51.20% 40.00% 0.00% 0.00% 45.00% 40.00% 0.00% 0.00% 0.00% |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage according to Weightage
You're not making it easy to provide help. You'll have to identify how you
did the calculations, because I can't get those numbers from your data. You also need to specify what you want done about the fact the percentages don't add up to 100%. Regards, Fred "Kash" wrote in message ... Preferred outcome is 51.20% 40.00% 0.00% 0.00% 45.00% 40.00% 0.00% 0.00% 0.00% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP WITH WEIGHTAGE | Excel Discussion (Misc queries) | |||
how to limit the Weightage of any data & distribute excess to othe | Excel Worksheet Functions | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
percentage | Excel Worksheet Functions | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel |