| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compute percentages
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 percentages
hi,
=CEILING(B1/A1,0.1) isabelle Le 2013-10-30 17:36, GWC a écrit : 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compute percentages
On 30/10/2013 21:36, 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 With some difficulty since most of them are ~ 9% -- Regards, Martin Brown |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compute Tax? | New Users to Excel | |||
| Average Percentages Excluding Zero Percentages | Excel Programming | |||
| auto compute | Excel Worksheet Functions | |||
| UDF to compute using ranges | Excel Programming | |||
| How do I compute ratios? | Excel Discussion (Misc queries) | |||
Linear Mode
