View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Range Penetration - formula based on percentage

Incomplete line:
Another way to directly run the calc "backwards" based is to use Goal Seek


should have read as:

Another way to directly run the calc "backwards" based on what is framed up
in your row2 [ie with D2 housing the formula: =(A2-B2)/(C2-B2)] is to use
Goal Seek ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---