Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Easy for you...add % increase column?

Help...I am sure this is easy for most of you! I have column D with pricing,
and want column E to calculate that pricing adding 10% (e=D +10%). I am new
at this...what would be the formula to do this? Thank you!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,942
Default Easy for you...add % increase column?

hi
in E2, enter.......
=D2+(D2*.1)

regards
FSt1

"luanne" wrote:

Help...I am sure this is easy for most of you! I have column D with pricing,
and want column E to calculate that pricing adding 10% (e=D +10%). I am new
at this...what would be the formula to do this? Thank you!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default Easy for you...add % increase column?

In E1 use the below formula and copy down as required

=D1*1.1

If this post helps click Yes
---------------
Jacob Skaria


"luanne" wrote:

Help...I am sure this is easy for most of you! I have column D with pricing,
and want column E to calculate that pricing adding 10% (e=D +10%). I am new
at this...what would be the formula to do this? Thank you!

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Easy for you...add % increase column?

Thank you. Will this then display the increase in column E (the whole
column) of all amounts in Column D ($1.00 example) by 10% (example $1.10)?

"Jacob Skaria" wrote:

In E1 use the below formula and copy down as required

=D1*1.1

If this post helps click Yes
---------------
Jacob Skaria


"luanne" wrote:

Help...I am sure this is easy for most of you! I have column D with pricing,
and want column E to calculate that pricing adding 10% (e=D +10%). I am new
at this...what would be the formula to do this? Thank you!

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default Easy for you...add % increase column?

Hi Luanne

---If D1 =100 E1 will display 110 (which is 100+10%).

---If you copy the formula down to E2; it displays 10%+D2 and so on

---If you want to display 10% of the entire amount in columnD in cell E1 use
the formula
=SUM(D:D)*1.1

If this post helps click Yes
---------------
Jacob Skaria


"luanne" wrote:

Thank you. Will this then display the increase in column E (the whole
column) of all amounts in Column D ($1.00 example) by 10% (example $1.10)?

"Jacob Skaria" wrote:

In E1 use the below formula and copy down as required

=D1*1.1

If this post helps click Yes
---------------
Jacob Skaria


"luanne" wrote:

Help...I am sure this is easy for most of you! I have column D with pricing,
and want column E to calculate that pricing adding 10% (e=D +10%). I am new
at this...what would be the formula to do this? Thank you!



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default Easy for you...add % increase column?

Hi
In E enter

=D1*1.1



"luanne" wrote:

Help...I am sure this is easy for most of you! I have column D with pricing,
and want column E to calculate that pricing adding 10% (e=D +10%). I am new
at this...what would be the formula to do this? Thank you!

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Easy for you...add % increase column?

In the cell E1 enter =D1*1.1

--
Dougal Everingham
Kompas Consulting

kompas [Danish] (instrument) for determining direction or to give
bearing

m: +61 431 475 606
e:
w:
www.KompasConsulting.com.au and w: www.linkedin.com/in/everingham


On Jul 9, 9:30*pm, luanne wrote:
Help...I am sure this is easy for most of you! *I have column D with pricing,
and want column E to calculate that pricing adding 10% *(e=D +10%). *I am new
at this...what would be the formula to do this? *Thank you!


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
Easy way to stack column data? colleen Excel Worksheet Functions 1 July 7th 08 12:06 AM
increase column by % Boss Mary Excel Discussion (Misc queries) 3 July 31st 07 01:51 AM
Stack multiple columns into one column... is there an easy way? Julian Excel Discussion (Misc queries) 2 September 16th 05 07:31 PM
Increase Column D by 10% dbrumit Excel Discussion (Misc queries) 3 June 7th 05 07:30 PM
Excel should provide an easy way to switch a column into a row, n. samsson Excel Discussion (Misc queries) 2 March 21st 05 04:20 PM


All times are GMT +1. The time now is 12:27 AM.

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

About Us

"It's about Microsoft Excel"