Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default Testing if a point is falling within the bounds of intersecting cu

In Excel 2000 and Excel 2003, I am trying to validate if specific (x,y)
coordinates fall within the area bounded by 4 intersecting curves with
equations "y=f(x)", and am looking for help to set this up. I have tried the
normal logic of IF, AND, OR but have not been successful at all.

Of the four functions of the type "y=f(x)". the fourth one is the CIE 1931
locus of the human eye response to colors, and is a very complex function.
The others are more like "y = mx+c". Since the complex function is
representing the boundary of an instrument's data output, the data will
always be bounded on that side. I am currently more concerned with the first
3 equations of the first order, and would just like to ensure that my data
points are within
their bounds.

Has anyone ever tried this in Excel, or am I the first one to venture into
this area?

--
Mukesh
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
test for falling with the bounds of intersecting 2 dimensional cur Mukesh Excel Worksheet Functions 3 August 29th 07 05:02 PM
Formula falling over in more than one cell moviegrrl Excel Worksheet Functions 5 May 25th 06 04:53 PM
How to fix lower and upper bounds for data charter_SKR Excel Worksheet Functions 1 April 10th 06 05:29 PM
Falling within a range ben simpson Excel Discussion (Misc queries) 2 March 14th 06 03:21 PM
RETURN intersecting value with known horizotal & vertical?? || cypher || Excel Worksheet Functions 4 February 2nd 05 09:27 PM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"