price increase uniformly in several cells
MartinW wrote:
Hi Johnny,=A1*2*110%or simpler=A1*2*1.1Should give you what you are after.
27-Aug-07
Hi Johnny
=A1*2*110
or simple
=A1*2*1.
Should give you what you are after. Although that does seem to be an awkwar
way to set up your spreadsheet. It appears to be a solution for one
particula
equation and not adjustable for different variables. Then again I can't see
you
data, or know the big picture of what you are trying to achieve
HT
Marti
Previous Posts In This Thread:
Formula for multiplying and adding percentage please help.
A pretty simple question I guess. I am trying to make a template to do
material take offs for a construction company. I am trying to add 10-15% to
various cells. An example of what I am after
A | B |
1 100 =A1*(2+10%
What I am getting is 200.1 when what I am expecting is 220 ... 100 * 2 = 200
+10% = 220
What in my formula do I have wrong ?
=E1*(100%+10%)ore1*1.
=E1*(100%+10%
o
e1*1.1
-
Don Guillet
Microsoft MVP Exce
SalesAid Softwar
(e-mail address removed)
I don't know how you get 200.
I don't know how you get 200.1, I get 210 because 100*2 = 200 + 10% (of 100
NOT 200) = 21
--
HT
Sand
In Perth, the ancient capital of Scotlan
and the crowning place of king
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.u
Ok still not what I am after sorry. Let me try to explain better.
Ok still not what I am after sorry. Let me try to explain better
Let say for track its 10' long and I need one on bottom of wall and one on
top on my spreadsheet I would like to enter the lf of wall and it calculate
the ammount of track I need, cost plus 10% for wast
A1 = 100 lf wal
B1 = A1 * 2 "Now thats 200 cause I need track for top and bottom. From that
200 I need to add 10% for waste/extra/overhead/profit. so { 100 x 2 + 10% =
220 lf} Im good from here cause in another cell or what ever I can do 220/10
and it will let me know for the sectin I need 22 pieces of 10' track to build
a wall 100' long.
I just cant get it to give me 10% off of 100 x 2 if gives me 10% off of 100
which is not what I am after
So A1 x 2 + and additional 10%
Thank
:
I dont know why I get 200.1 ither why I am here.
I dont know why I get 200.1 ither why I am here. So is there a formula that
makes this correct
A | B | c
1 100 22
So what I am trying to get is 100 x 2 ... then an additional 10% off the 20
100 x 2 = 200 + 10% = 22
Can I do this in B2 somehow
:
=A1*2+(A1*2*10%)or=A1*220%-- HTHSandyIn Perth, the ancient capital of
=A1*2+(A1*2*10%
o
=A1*220
-
HT
Sand
In Perth, the ancient capital of Scotlan
and the crowning place of king
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Hi Johnny,=A1*2*110%or simpler=A1*2*1.1Should give you what you are after.
Hi Johnny
=A1*2*110
or simple
=A1*2*1.
Should give you what you are after. Although that does seem to be an awkwar
way to set up your spreadsheet. It appears to be a solution for one
particula
equation and not adjustable for different variables. Then again I can't see
you
data, or know the big picture of what you are trying to achieve
HT
Marti
increase prices by 25% in several cells
increase prices by 25% in several cells
increase prices by 25% in several cells
increase prices by 25% in several cells
Submitted via EggHeadCafe - Software Developer Portal of Choice
Excel Macros - Create And Run in C# at Runtime
http://www.eggheadcafe.com/tutorial...fc-5ef649a032b9/excel-macros--create-and.aspx