Formula Help
 

Hello,

Im trying to take a number (for this example 100)located in "A1"

and times it by a churn rate of located in 3% in "A2", (returning actually
97% of 100)

and then I need to times the resulting number (in this case 97) by s 5%
growth rate located in "A3" for a return of 102.

Thanks for the help
Jim

Formula Help
 

Didn't you already ask this, and receive several replies?

Jim wrote:

Hello,

Im trying to take a number (for this example 100)located in "A1"

and times it by a churn rate of located in 3% in "A2", (returning actually
97% of 100)

and then I need to times the resulting number (in this case 97) by s 5%
growth rate located in "A3" for a return of 102.

Thanks for the help
Jim

Formula Help
 

We just need to adjust the values to make the percentages work:

=A1*(1-A2)*(1+A3)


--
Gary''s Student - gsnu200838


"Jim" wrote:

Hello,

Im trying to take a number (for this example 100)located in "A1"

and times it by a churn rate of located in 3% in "A2", (returning actually
97% of 100)

and then I need to times the resulting number (in this case 97) by s 5%
growth rate located in "A3" for a return of 102.

Thanks for the help
Jim

Formula Help
 

Thanks for the response. Just a quick question. What does the "1-"
accomplish in the formula?

Thanks

"Gary''s Student" wrote:

We just need to adjust the values to make the percentages work:

=A1*(1-A2)*(1+A3)


--
Gary''s Student - gsnu200838


"Jim" wrote:

Hello,

Im trying to take a number (for this example 100)located in "A1"

and times it by a churn rate of located in 3% in "A2", (returning actually
97% of 100)

and then I need to times the resulting number (in this case 97) by s 5%
growth rate located in "A3" for a return of 102.

Thanks for the help
Jim

Formula Help
 

and times it by a churn rate of located in 3% in "A2", (returning
actually 97% of 100)

=A1*(1-A2)*(1+A3)

Thanks for the response. Just a quick question. What does the "1-"
accomplish in the formula?

It does the calculation that you described in words: 100% - 3% = 97%

use following formula in cell B1
=(A1*(100-A2)/100)*(100+A3)/100
Note:format A2 and A3 as general



Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com