Easy for you...add % increase column?

  • Thread starter Thread starter luanne
  • Start date Start date
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!
 
In E1 use the below formula and copy down as required

=D1*1.1

If this post helps click Yes
 
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)?
 
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
 
Back
Top