how can I find out a total as a percentage using absolute cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to use a formula/function to calculate the total for an employee as a
percentage of the grand total using absolute cell reference can you please
tell me what to do. Thank you
 
Sounds like a homework problem to me. The formula for percentage of total is:

=a1/$a$25

where a1 is the, in your example, total for an employee, and a25 is the grand
total. Format this cell as a percent.

The $ makes the reference absolute -- meaning it will not change when you copy
the formula. This allows you to copy down the formula, and it will work for all
other employee totals.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get percentage of whole 2
Calculating percentage growth rate from a cumulative figure 4
maintaining constant percentage 1
Adding Fractions and Displaying as a percentage. 6
Percentage Increase 13
Pivot Table Percentage of Sub-Total 7
Need a formula 5
Creating a Formula in Excel 4

Back
Top