View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Johnnychadrice Johnnychadrice is offline
external usenet poster
 
Posts: 3
Default Formula for multiplying and adding percentage please help.

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 ?