Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

Formula for multiplying and adding percentage please help.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Johnnychadrice - 27 Aug 2007 23:36 GMT
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 ?
Don Guillett - 27 Aug 2007 23:46 GMT
=E1*(100%+10%)
or
e1*1.10

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>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%
[quoted text clipped - 11 lines]
> +10% = 220.
> What in my formula do I have wrong ?
Johnnychadrice - 28 Aug 2007 00:04 GMT
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

> =E1*(100%+10%)
> or
[quoted text clipped - 15 lines]
> > +10% = 220.
> > What in my formula do I have wrong ?
Sandy Mann - 27 Aug 2007 23:49 GMT
I don't know how you get 200.1, I get 210 because 100*2 = 200 + 10% (of 100
NOT 200) = 210

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

>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%
[quoted text clipped - 11 lines]
> +10% = 220.
> What in my formula do I have wrong ?
Johnnychadrice - 28 Aug 2007 00:10 GMT
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             220
2

So what I am trying to get is 100 x 2 ... then an additional 10% off the 200
100 x 2 = 200 + 10% = 220
Can I do this in B2 somehow?

> I don't know how you get 200.1, I get 210 because 100*2 = 200 + 10% (of 100
> NOT 200) = 210
[quoted text clipped - 14 lines]
> > +10% = 220.
> > What in my formula do I have wrong ?
Sandy Mann - 28 Aug 2007 00:16 GMT
=A1*2+(A1*2*10%)

or

=A1*220%

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

>I dont know why I get 200.1 ither why I am here. So is there a formula that
> makes this correct?
[quoted text clipped - 29 lines]
>> > +10% = 220.
>> > What in my formula do I have wrong ?
MartinW - 28 Aug 2007 01:02 GMT
Hi Johnny,

=A1*2*110%
or simpler
=A1*2*1.1

Should give you what you are after. Although that does seem to be an awkward
way to set up your spreadsheet. It appears to be a solution for one
particular
equation and not adjustable for different variables. Then again I can't see
your
data, or know the big picture of what you are trying to achieve.

HTH
Martin

>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%
[quoted text clipped - 11 lines]
> +10% = 220.
> What in my formula do I have wrong ?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.