Home 
Search 
Today's Posts 
#1




Add on 10%
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 
#2




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 
#3




Thanks for that Garfield. I have done that and it has worked, but now it
wont put the numbers that should be a WHOLE number. EG  I WANT the decimal point as 1.0759  BUT it is only showing 1075.9. I have played around with the decimal points in the tools, options menu. Thanks "garfieldnodie" wrote: 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 
#4




I think you multiplied by 1060, when you should have multiplied
by 1.06 or 106%. And in Tools  Options  Edit, uncheck the box for "Fixed decimal places". Leanne wrote: Thanks for that Garfield. I have done that and it has worked, but now it wont put the numbers that should be a WHOLE number. EG  I WANT the decimal point as 1.0759  BUT it is only showing 1075.9. I have played around with the decimal points in the tools, options menu. Thanks "garfieldnodie" wrote: 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 
#5




THANK YOU SO MUCH!!!!!
"garfieldnodie" wrote: I think you multiplied by 1060, when you should have multiplied by 1.06 or 106%. And in Tools  Options  Edit, uncheck the box for "Fixed decimal places". Leanne wrote: Thanks for that Garfield. I have done that and it has worked, but now it wont put the numbers that should be a WHOLE number. EG  I WANT the decimal point as 1.0759  BUT it is only showing 1075.9. I have played around with the decimal points in the tools, options menu. Thanks "garfieldnodie" wrote: 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 
Reply 
Thread Tools  Search this Thread 
Display Modes  

