| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple Formula Help
This seems simple enough but I can't get it right. What formula do I use to
find the percent of a total amount? Example $1124 $55650 $950 --------- $57, 724 (total) What % is each value above of the total? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Simple Formula Help
Hi Chris
=A1/A4 Carim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Simple Formula Help
Thanks!
"Carim" wrote: Hi Chris =A1/A4 Carim |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Simple Formula Help
Supposing your data is in cells A1:A3, and the total in A4, you can enter a
formula like this on cell B1: =A1/$A$4 Format the cell as percentaje and copy it to cells B2 and B3. Hope this helps, Miguel. "Chris" wrote: This seems simple enough but I can't get it right. What formula do I use to find the percent of a total amount? Example $1124 $55650 $950 --------- $57, 724 (total) What % is each value above of the total? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Simple Formula Help
Chris wrote:
What formula do I use to find the percent of a total amount? Example $1124 $55650 $950 --------- $57, 724 (total) What % is each value above of the total? =A1/$A$4 =A2/$A$4 =A3/$A$4 Format each cell as Percentage with Decimal Places 2 (click on Format Cells Number). Using $A$4 in the denominator facilitates copying the formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| i know this is simple, but driving me nuts - formula | Excel Worksheet Functions | |||
| Simple Excel Formula Help | New Users to Excel | |||
| When inserting a simple "Sum" formula all I get is the formula. | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
Hybrid Mode
