Increase by % Formula
 

Hello,

I have a row of #'s, in the row below I would like to increase each cell's
number by 3.5%, in the next row 4%, etc. What is the formula?

Example of what I'm doing:
In Cell A1 is 60,000
In Cell B1 I put the following formula: =A1*3.5%
(Answer comes out to 2,100, which is correct, but then I want ithe answer to
be 62,100 - it's not adding the 2,100 to the 6,000 for the answer). Please
help!

Thank you.

Increase by % Formula
 

"Trying Hard" wrote in message
...
Hello,

I have a row of #'s, in the row below I would like to increase each cell's
number by 3.5%, in the next row 4%, etc. What is the formula?

Example of what I'm doing:
In Cell A1 is 60,000
In Cell B1 I put the following formula: =A1*3.5%
(Answer comes out to 2,100, which is correct, but then I want ithe answer
to
be 62,100 - it's not adding the 2,100 to the 6,000 for the answer).
Please
help!

Thank you.


Two methods:
B1=A1*103.5 or
B1=A1+(A1*3.5%)

Increase by % Formula
 

Try this
=A1+(A1*3.5%)
--
Thanks
Suleman Peerzade


"Trying Hard" wrote:

Hello,

I have a row of #'s, in the row below I would like to increase each cell's
number by 3.5%, in the next row 4%, etc. What is the formula?

Example of what I'm doing:
In Cell A1 is 60,000
In Cell B1 I put the following formula: =A1*3.5%
(Answer comes out to 2,100, which is correct, but then I want ithe answer to
be 62,100 - it's not adding the 2,100 to the 6,000 for the answer). Please
help!

Thank you.

Increase by % Formula
 

Slight correction to your first formula:

B1 = A1*1.035

Also, you might consider putting the percentage increases in separate cells.
If the 3.5% figure were in G1, then

B1 = A1*(1+$g$1)

This has two advantages. First -- it's easier for someone else (or even
you) to see what's going on. Second, it's easier to change your assumptions
and watch what's happening.

HTH

"Gordon" wrote:

"Trying Hard" wrote in message
...
Hello,

I have a row of #'s, in the row below I would like to increase each cell's
number by 3.5%, in the next row 4%, etc. What is the formula?

Example of what I'm doing:
In Cell A1 is 60,000
In Cell B1 I put the following formula: =A1*3.5%
(Answer comes out to 2,100, which is correct, but then I want ithe answer
to
be 62,100 - it's not adding the 2,100 to the 6,000 for the answer).
Please
help!

Thank you.


Two methods:
B1=A1*103.5 or
B1=A1+(A1*3.5%)

Increase by % Formula
 

What I would do is:
1. Move everything over to Column B so the first value is in B1
2. In A2, put 3.5%
3. In B2, put =B1+(B1*$A$2)
4. Use the copy right function to copy that formula accross Row 2
5. In A3, put 4%
6. In B3, use the same formula except change $A$2 to $A$3
7. Use the copy right function to copy that formula accross Row 3
8. Continue that for as many rows down that you are going.


"Trying Hard" wrote:

Hello,

I have a row of #'s, in the row below I would like to increase each cell's
number by 3.5%, in the next row 4%, etc. What is the formula?

Example of what I'm doing:
In Cell A1 is 60,000
In Cell B1 I put the following formula: =A1*3.5%
(Answer comes out to 2,100, which is correct, but then I want ithe answer to
be 62,100 - it's not adding the 2,100 to the 6,000 for the answer). Please
help!

Thank you.

Increase by % Formula
 

Slight Correct, sorry.

use the formula =B$2+(B$2*A3).

Sorry about that


"JasonP CCTM LV" wrote:

What I would do is:
1. Move everything over to Column B so the first value is in B1
2. In A2, put 3.5%
3. In B2, put =B1+(B1*$A$2)
4. Use the copy right function to copy that formula accross Row 2
5. In A3, put 4%
6. In B3, use the same formula except change $A$2 to $A$3
7. Use the copy right function to copy that formula accross Row 3
8. Continue that for as many rows down that you are going.


"Trying Hard" wrote:

Hello,

I have a row of #'s, in the row below I would like to increase each cell's
number by 3.5%, in the next row 4%, etc. What is the formula?

Example of what I'm doing:
In Cell A1 is 60,000
In Cell B1 I put the following formula: =A1*3.5%
(Answer comes out to 2,100, which is correct, but then I want ithe answer to
be 62,100 - it's not adding the 2,100 to the 6,000 for the answer). Please
help!

Thank you.

Increase by % Formula
 

Sorry, one more correction

Use =B$2+(B$2*$A3)

Sorry, this is my first time contributing to the Online discussion group,
and wasnt thinking all the way through.