![]() |
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! |
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! |
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! |
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! |
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! |
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! |
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