| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to know the % of a grand total
I have a problem and I can't figure out the formula. The cost is 2.99; #of
unit is 25 and total cost is $74.75. I need the % of the grand total. Can someone please help me with this problem. -- Thank you Michelle |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to know the % of a grand total
If cost is in a1, and grand total is in b1, % of total is:
=a1/b1 Format as percent Regards, Fred. "Michelle" .(donotspam) wrote in message ... I have a problem and I can't figure out the formula. The cost is 2.99; #of unit is 25 and total cost is $74.75. I need the % of the grand total. Can someone please help me with this problem. -- Thank you Michelle |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
