Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 10th 10, 06:58 PM posted to microsoft.public.excel.newusers
Sue Sue is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 285
Default how do I add 3% or 5 % to a column

I need to add a percentage to a column for my price list .
Can someone please help me

  #2   Report Post  
Old February 10th 10, 07:18 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default how do I add 3% or 5 % to a column

Put 1.03 (or 1.05) in an empty cell.
Edit|copy that cell
Select the range to adjust.
edit|paste special|choose multiply and values

Clean up that cell with 1.03/1.05 in it.

Sue wrote:

I need to add a percentage to a column for my price list .
Can someone please help me


--

Dave Peterson
  #3   Report Post  
Old February 10th 10, 07:19 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 694
Default how do I add 3% or 5 % to a column

HI Sue
For 3%, type 1.03 in a cell copy it then select your column ( Range)
goto EditPaste special and select Multiply. you can delete the 1.03 and change
it to 1.05
and do the same thing again for your other range.
HTH
John
"Sue" wrote in message
...
I need to add a percentage to a column for my price list .
Can someone please help me


  #4   Report Post  
Old February 10th 10, 07:23 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default how do I add 3% or 5 % to a column

In cell A 1 I have 100

In cell B 1 I have 0.03

In cell C 1 I have:-

=(A1*B1)+A1

- giving a result of 103 in cell C 1

If my comments have helped please hit Yes.

Thanks.

"Sue" wrote:

I need to add a percentage to a column for my price list .
Can someone please help me

  #5   Report Post  
Old July 6th 21, 07:48 AM
Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default drag formula to a column

Hello!

if you want to add 3% or 5% to a column, first, we'll name the base column as Column A, then if we want to add 3% to 5% on to column A, we just need to put 1.03 or 1.05 to a random cell, Z1. Now, we can place a formula on another column, B, and use the formula:

=A*Z1

on Column B, and just drag it until the last entry of the column A. now we get a 3% increase for all the entries in Column A which are in Column B.

For more tips on excel and Financial Models, you can check this out. Hope this Helps!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing date column A & time column B to get info from column TVGuy29 Excel Discussion (Misc queries) 1 January 24th 08 10:50 PM
Return text in Column A if Column B and Column K match jeannie v Excel Worksheet Functions 4 December 13th 07 08:36 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look [email protected] Excel Discussion (Misc queries) 1 December 27th 06 06:47 PM
divide column(x) by column(y) to give column(x/y) in excel? James New Users to Excel 1 November 10th 06 12:59 AM
formula : =(column A)+(column B)-(column C). Why won't it work? Kristin Drover Excel Discussion (Misc queries) 3 October 18th 06 08:48 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017