View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default test for falling with the bounds of intersecting 2 dimensional cur

How many intersecting curves define your area? If it is defined by 2
curves, such as where f1(x) is =x and f2(x) is =x^2-5*x, then your formula
for (xvalue,yvalue) being within the area would be
=(yvalue<f1(xvalue))<(yvalue<f2(xvalue))
--
David Biddulph

"Mukesh" wrote in message
...
I am trying to validate if specific (x,y) coordinates fall within the area
bounded by 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.

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