Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make column C a percentage of column B
I need to calculate different percentages for fixed numbers I have in column
B. How do I make column C a percentage of B, column D a different percentage of B, and so on. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make column C a percentage of column B
Hi,
not pretty sure what you want, you need column C to show percentage of B based on a column B total ? if yes do =B1$B$100 B100 = cell with the total dopy formula down if this is not what you were looking for please give an example thanks "dbcruzin" wrote: I need to calculate different percentages for fixed numbers I have in column B. How do I make column C a percentage of B, column D a different percentage of B, and so on. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make column C a percentage of column B
Worked example:-
1. In cell B 1 enter:- 100 2. In cell C 1 enter:- 50 3. In cell D 1 enter:- =(C1/B1) The result of this formula will show as:- 50% (Make sure that cell D 1 is formatted as follows:- - single right hand click in cell D 1 - from the options that are launched select Format Cells (by clicking on it) - Number tab - Category: (make sure that this is set to Percentage and then hit OK)). Apply the above to your situation and you should come up with what you want. Please hit Yes if my comments have helped. Thanks. "dbcruzin" wrote: I need to calculate different percentages for fixed numbers I have in column B. How do I make column C a percentage of B, column D a different percentage of B, and so on. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make column C a percentage of column B
B1 contains 100
C1 =$B1*.25 returns 25 D1 =$B1*.50 returns 50 and so on Gord Dibben MS Excel MVP On Mon, 21 Dec 2009 07:45:01 -0800, dbcruzin wrote: I need to calculate different percentages for fixed numbers I have in column B. How do I make column C a percentage of B, column D a different percentage of B, and so on. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a column be formated to make any entry in that column capitali | Excel Discussion (Misc queries) | |||
When I make a row absolute, but column relative, the column stays. | Excel Discussion (Misc queries) | |||
how to make one column copy from one sheet to anoth column w/o zer | Excel Discussion (Misc queries) | |||
Excel, when column A and B have same name make column C add up in mail merge | Excel Discussion (Misc queries) | |||
How do I make a column that calculates gross margin percentage | Excel Worksheet Functions |