Good afternoon ,I am trying to solve a problem with two data series in a graph where I need find the interception of the two series and find automatically a value .The problem is more easy to understand if is seen the examples book that I attach to the post , I am trying to generate automatically the value 1.8 in the example1 , 21.5 in the example2 , 65 in the example3 and 0 in the example 4.
Someone can help me please? I'll be very grateful for any help.
Last edited by josel2820; 10-30-2013 at 12:01 PM.
Using only your linear portion of your graph, I would use this equation for y = mx + b
Formula:
Please Login or Register to view this content.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Please ,check the new examples book that I attached again to the post. I am trying to generate automatically the value 1.8 in the example1 , 21.5 in the example2 , 65 in the example3 and 0 in the example 4.
Last edited by josel2820; 10-30-2013 at 11:58 AM.
You can use this formula to determine intersection within each segment.
=IF(AND(C13>=$I$33,C14<=$I$33),TREND(B13:B14,C13:C14,$I$33),FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks