Thread: Formula Help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
pomegranate-man[_2_] pomegranate-man[_2_] is offline
external usenet poster
 
Posts: 14
Default 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%