View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
 
Posts: 740
Default algebra by excel

hello again,

Is there a simpler way to have a short formula?

=IF(A6=A3,B3,IF(A6<A2,(A6-A1)*C1+B1,IF(A6<A4,B3+(MAX(SQRT(D3^2-IF(A6<A4,A6-A3,0)^2)*(IF(A6<A4,A6-A3,0)<0),SQRT(D3^2-IF(A6<A3,A3-A6,0)^2)*(IF(A6<A3,A3-A6,0)<0))-D3),IF(A6<A5,(A6-A4)*C4+B4,"XXX"))))

this is a line+circ.curve+line equation to get elevation...I hope i can
simplify this for easy remembering..

--
regards,