Thread: Add on 10%
View Single Post
  #2   Report Post  
garfield-n-odie
 
Posts: n/a
Default

Multiply by 106%.

Leanne wrote:

I want to add on 6% to each cell. Ranges are from B11 - L61. I have put a 6
in a cell by it self, highlighted, paste special, then multiply.

My problem is - it only displays how much 6% is of the sum that I have put
into the cell.

E.G In one cell, I have .58900 - I multiply that by 6.0% and get .035340.
Which is correct. BUT I need .58900 + 0.03534 to SHOW that .58900+0.03534 =
0.62434.

How do I do this???

Leanne