Easy for you...add % increase column?

L

luanne

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!
 
J

Jacob Skaria

In E1 use the below formula and copy down as required

=D1*1.1

If this post helps click Yes
 
L

luanne

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)?
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top