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 ?