| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compute percentage
How can I divide B by A and get 10%?
A B 1 0.34 0.03 2 0.34 0.03 3 0.68 0.06 4 0.67 0.06 5 0.67 0.06 6 0.67 0.06 7 0.78 0.07 8 0.89 0.08 9 0.33 0.03 10 0.66 0.06 11 0.66 0.06 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compute percentage
=ROUND(B1/A1,1) enter in C1 then copy down.
Gord On Wed, 30 Oct 2013 14:38:35 -0700 (PDT), GWC wrote: How can I divide B by A and get 10%? A B 1 0.34 0.03 2 0.34 0.03 3 0.68 0.06 4 0.67 0.06 5 0.67 0.06 6 0.67 0.06 7 0.78 0.07 8 0.89 0.08 9 0.33 0.03 10 0.66 0.06 11 0.66 0.06 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compute percentages | Excel Programming | |||
| Compute Tax? | New Users to Excel | |||
| Formula to compute letter grade based on percentage grade | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| compute a percentage | New Users to Excel | |||
Linear Mode
