ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Easy for you...add % increase column? (https://www.excelbanter.com/excel-worksheet-functions/236343-easy-you-add-%25-increase-column.html)

Luanne

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!

FSt1

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!


Jacob Skaria

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!


Dougal Everingham

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!



Eduardo

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!


Luanne

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!


Jacob Skaria

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!



All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com