Posted to microsoft.public.excel.worksheet.functions

driller

external usenet poster

Posts: 740

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,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Algebra	[email protected]	Excel Worksheet Functions	5	December 28th 07 05:10 PM
Algebra in Excel	sstexas	Excel Discussion (Misc queries)	3	June 21st 07 08:17 AM
Simple algebra and excel	[email protected]	Excel Worksheet Functions	5	March 8th 07 07:21 PM
Algebra	Irish3538	Excel Worksheet Functions	2	October 16th 06 06:15 PM
how do i write a Algebra formula in excel sheet	Saravanan	Excel Discussion (Misc queries)	1	October 9th 06 10:47 AM

All times are GMT +1. The time now is 01:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us