| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentage
I am trying to figure out the total percentage of 2 cell for example E166 HAS
159 AND J166 HAS 139 HOW WOULD I GET THE PERCENTAGE OR HOW DO YOU WRITE IT-- Sgt.Gonzalez |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
percentage
=J156/E156
and format the formula cell to percentage -- Jacob "Gonzalez" wrote: I am trying to figure out the total percentage of 2 cell for example E166 HAS 159 AND J166 HAS 139 HOW WOULD I GET THE PERCENTAGE OR HOW DO YOU WRITE IT-- Sgt.Gonzalez |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
percentage
hi
not sure exactly what you mean. i am assuming that you mean as a per cent of the total of the 2. for E166....=E166/(E166+J166) for J166....=J166/(E166+J166) regards FSt1 "Gonzalez" wrote: I am trying to figure out the total percentage of 2 cell for example E166 HAS 159 AND J166 HAS 139 HOW WOULD I GET THE PERCENTAGE OR HOW DO YOU WRITE IT-- Sgt.Gonzalez |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage | New Users to Excel | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| percentage | Excel Worksheet Functions | |||
| percentage | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
Linear Mode
