View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
se7098 se7098 is offline
external usenet poster
 
Posts: 79
Default goal seek using multiple criteria to arrive at desired number

i am looking for a way to arrive at a specified number of new hires
accounting for a % loss each step along the way.

I need a total number of 100 starts...i lose the percantages listed below at
each step...the ??? represents the value i need to find in order to have 100
start.

So how many do i need in each step to end up at 100.

Total Number Needed = 100

step 1 step 2 step 3
step 4
dq% # needed dq% # needed dq % # needed dq% # needed
50% ??? 25% ??? 15% ??? 5%
???