Tell us what the math is (not the Excel)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"driller" wrote in message
...
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,