Home |
Search |
Today's Posts |
#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! |
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) |