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 ?