Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I markup a column of numbers without adding a column?
I am trying to markup a column of numbers but do not wish to add a column
(eg. Column A * .05 for Column B). Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I markup a column of numbers without adding a column?
You mean you want to add 5% to a range of cells? If so,
Enter 1.05 in an empty cell. Copy that cell. Highlight the range you want to change Right-click, choose Paste Special...MultiplyOK Delete the 1.05 if desired. Regards, Fred "Afreshb" wrote in message ... I am trying to markup a column of numbers but do not wish to add a column (eg. Column A * .05 for Column B). Is this possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I markup a column of numbers without adding a column?
If your data is in A1:A99, you could use a formula like:
=a1*.05 Or probably =a1*1.05 (since it's a markup) and drag down. I'm not sure what you mean about not adding a column, though. ========= Another approach--with your data in A2:A99 (not row 1!) This would go in B2: =a2*$B$1 and drag down You'd put 1.05 or 105% or .05 or 5% (or whatever you wanted) Afreshb wrote: I am trying to markup a column of numbers but do not wish to add a column (eg. Column A * .05 for Column B). Is this possible? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I markup a column of numbers without adding a column?
I would say OP does not want to use a helper column.
Wants to do it in situ. Gord On Tue, 02 Feb 2010 10:31:34 -0600, Dave Peterson wrote: I'm not sure what you mean about not adding a column, though. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I markup a column of numbers without adding a column?
Could be.
Gord Dibben wrote: I would say OP does not want to use a helper column. Wants to do it in situ. Gord On Tue, 02 Feb 2010 10:31:34 -0600, Dave Peterson wrote: I'm not sure what you mean about not adding a column, though. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding column numbers | Excel Discussion (Misc queries) | |||
ADDING NUMBERS IN A COLUMN | New Users to Excel | |||
adding numbers from column B, while condition on column A | Excel Discussion (Misc queries) | |||
Adding a % value to a column of numbers | Excel Worksheet Functions | |||
Adding numbers in a column | New Users to Excel |