Formula Help

J

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
 
G

Gary''s Student

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

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

Jim

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

Thanks
 
P

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?
Click to expand...

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