View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Hall John Hall is offline
external usenet poster
 
Posts: 1
Default Find Max of Curve Equation

I have scoured the newsgroups and web and can't seem to find an anwser
to this.

I need to find the max of an equation. where the equation is in this
form 1/(1-e^(z1-x))*(1-1/(1+e^(z2-x))*.........*(1-1/(1+e^(zn-x)).

Where there are n number of z values that are know. Meaning that z is
not a variable but different constants.

I can calculate the slope at a specific value of x but want to solve
for x where F'(x) = 0.

Any help?

Thanks,
John