Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiplying non consecutive rows, than adding it. | Excel Discussion (Misc queries) | |||
Multiplying non consecutive rows, then adding it. | Excel Worksheet Functions | |||
Sumproduct multiplying instead of adding | Excel Worksheet Functions | |||
Array formula and multiplying conditions | Excel Worksheet Functions | |||
Adding percentage as interest to a total | Excel Worksheet Functions |