| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Percentages
Thanks. I now have 40%-95% across the top and 100-520 down the side. Now
does anyone know the formula for percentage. I want to be able to see what ex. 85% of 320. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making Percentages
85% of 320 is 320*0.85.
Dave -- Brevity is the soul of wit. "creating a reference list" wrote: Thanks. I now have 40%-95% across the top and 100-520 down the side. Now does anyone know the formula for percentage. I want to be able to see what ex. 85% of 320. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making Percentages
Multiply the row/column intersection
If B1=40% (formatted as %) and A2=100 then in B2 put: =B$1*$A2 Copy across and down and you will have your matrix. HTH "creating a reference list" wrote: Thanks. I now have 40%-95% across the top and 100-520 down the side. Now does anyone know the formula for percentage. I want to be able to see what ex. 85% of 320. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making Percentages
Hi
Try entering in cell B2 =$A2*B$1 Copy across and down to fill the matrix -- Regards Roger Govier "creating a reference list" m wrote in message ... Thanks. I now have 40%-95% across the top and 100-520 down the side. Now does anyone know the formula for percentage. I want to be able to see what ex. 85% of 320. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stacked bar chart with percentages | Charts and Charting in Excel | |||
| Rounding percentages problem need a solution for | Excel Discussion (Misc queries) | |||
| What format do I use to mail merge percentages? | Excel Discussion (Misc queries) | |||
| copying sheets with percentages | Excel Discussion (Misc queries) | |||
| Calculating Percentages with Variables | Excel Worksheet Functions | |||
Linear Mode
