# Percentage Not Calculating Correctly

This is a discussion on Percentage Not Calculating Correctly within the Excel Questions forums, part of the Question Forums category; I am having the hardest time understanding what is going on with my spreadsheet. I have a spreadsheet that is ...

1. ## Percentage Not Calculating Correctly

I am having the hardest time understanding what is going on with my spreadsheet. I have a spreadsheet that is taking four different data inputs and adding them up to figure out what percentage of that work type as it relates to the average processing times. This is the formula that I am using for 510K the bottom

=((AK11/(AK14/'Workload Distribution'!F13))*(AK9)/(SUM(AK9:AN9)))

F13 being the average processing time of 5 hours.

What I don't understand is the second field for Internal Requests is:

=((AK11/(AL14/'Workload Distribution'!G13))*((AL9)/(SUM(AK9:AN9))))

The percentage that is coming out seems to be problem because when I manually put the percentage in it calculates fine. If I do not the values come out the same even though they are not. Can someone explain to me what I am doing wrong. Thank you very much.

 May 510k Internal Requests EIR PMA 18 3 0 0 Required Monthly Hours 146 Hours Logged by Work Type 510k Internal Requests EIR PMA 90 9 0 0 Actions Needed by Work Type 510k Internal Requests EIR PMA 11 46 49 4 Break Down Total Pages Boxes Avg Page Total Avg Box Total 3020 930 201 62 Hourly Breakdown by Work Type 510k Internal Requests EIR PMA 6.94 6.94

2. ## Re: Percentage Not Calculating Correctly

I am using Excel 2003. Thanks for the help.

3. ## Re: Percentage Not Calculating Correctly

Originally Posted by TRAQ
I am having the hardest time understanding what is going on with my spreadsheet. I have a spreadsheet that is taking four different data inputs and adding them up to figure out what percentage of that work type as it relates to the average processing times. This is the formula that I am using for 510K the bottom

=((AK11/(AK14/'Workload Distribution'!F13))*(AK9)/(SUM(AK9:AN9)))

F13 being the average processing time of 5 hours.

What I don't understand is the second field for Internal Requests is:

=((AK11/(AL14/'Workload Distribution'!G13))*((AL9)/(SUM(AK9:AN9))))

The percentage that is coming out seems to be problem because when I manually put the percentage in it calculates fine. If I do not the values come out the same even though they are not. Can someone explain to me what I am doing wrong. Thank you very much.

 May 510k Internal Requests EIR PMA 18 3 0 0 Required Monthly Hours 146 Hours Logged by Work Type 510k Internal Requests EIR PMA 90 9 0 0 Actions Needed by Work Type 510k Internal Requests EIR PMA 11 46 49 4 Break Down Total Pages Boxes Avg Page Total Avg Box Total 3020 930 201 62 Hourly Breakdown by Work Type 510k Internal Requests EIR PMA 6.94 6.94

4. ## Re: Percentage Not Calculating Correctly

Nice image. How does one connect the various pieces of what I assume are worksheet ranges to the formula you posted?

5. ## Re: Percentage Not Calculating Correctly

Sorry about that. The horizontal axis columns are AK, AL, AM, AN and the vertical axis rows begin at 7 (MAY) and end at 23 (6.94). Hope this clarifies it for you. Thanks for the help.

6. ## Re: Percentage Not Calculating Correctly

What is G13??? In your second equation???

7. ## Re: Percentage Not Calculating Correctly

G13 is the number 3 which indicates the time it takes to complete one internal request action.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•