| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I find out a total as a percentage using absolute cell
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can I find out a total as a percentage using absolute cell
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. -- Regards, Fred "JoJo" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Linear Mode
