Formula Help

[Jim]

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

 

[Bob I]

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

 

[Gary''s Student]

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

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

 

[Jim]

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

Thanks

 

[pomegranate-man]

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

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%