Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|