Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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 ?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiplying non consecutive rows, than adding it. RF Excel Discussion (Misc queries) 13 July 6th 07 02:32 PM
Multiplying non consecutive rows, then adding it. RF Excel Worksheet Functions 8 July 4th 07 10:46 PM
Sumproduct multiplying instead of adding denise Excel Worksheet Functions 4 June 15th 07 09:26 PM
Array formula and multiplying conditions KR Excel Worksheet Functions 6 September 22nd 06 12:33 AM
Adding percentage as interest to a total Cath Excel Worksheet Functions 3 April 15th 06 01:03 PM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"