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 |
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 |
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 "garfield-n-odie" 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 |
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 "garfield-n-odie" 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 |
THANK YOU SO MUCH!!!!!
"garfield-n-odie" 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 "garfield-n-odie" 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 |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com