Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Easy way to stack column data? | Excel Worksheet Functions | |||
increase column by % | Excel Discussion (Misc queries) | |||
Stack multiple columns into one column... is there an easy way? | Excel Discussion (Misc queries) | |||
Increase Column D by 10% | Excel Discussion (Misc queries) | |||
Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) |