View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Johnnychadrice Johnnychadrice is offline
external usenet poster
 
Posts: 3
Default Formula for multiplying and adding percentage please help.

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 waste

A1 = 100 lf wall
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%

Thanks
"Don Guillett" wrote:

=E1*(100%+10%)
or
e1*1.10

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Johnnychadrice" wrote in message
...
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 | C
1 100 =A1*(2+10%)
2
3
4

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 ?