#1   Report Post  
Old June 28th 05, 12:59 AM
Leanne
 
Posts: n/a
Default 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   Report Post  
Old June 28th 05, 01:08 AM
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


  #3   Report Post  
Old June 28th 05, 02:06 AM
Leanne
 
Posts: n/a
Default

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



  #4   Report Post  
Old June 28th 05, 02:41 AM
garfield-n-odie
 
Posts: n/a
Default

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




  #5   Report Post  
Old June 28th 05, 03:09 AM
Leanne
 
Posts: n/a
Default

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017