=A1*2+(A1*2*10%)

or

=A1*220%

--
HTH

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


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


"Johnnychadrice" wrote in message
...
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?


"Sandy Mann" wrote:

I don't know how you get 200.1, I get 210 because 100*2 = 200 + 10% (of
100
NOT 200) = 210

--
HTH

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


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


"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 ?