# How to identify quadrants for points of a graph with boundary conditions?

#### pv33

##### New Member
I tried using the if statement but its not working 100%. so I calculated two values of d* and Ry and plotted a graph. I added the boundary conditions to the graph as Ry=1, D*=ry, d*=-ryln(ry), d=sqrt(3.14/2*ry). This gave me lines and divided the graph into 4 quadrants. The graph is in log scale. I name each quadrant as regime 1 ,2 ,3 ,4

Now since these points fall all over the graph I am trying to write something that will tell me which regime that point belongs to. I tried using if statement but I am making some mistake as eventhough points are in regime 2 and 4 I only get 1 or 3. my logical reasoning is not correct and would like some help if possible

Thank you

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### Fluff

##### MrExcel MVP, Moderator
Cross posted How to identify quadrants for points of a graph with boundary conditions?

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

Replies
13
Views
235
Replies
1
Views
368
Replies
3
Views
106
Replies
0
Views
118
Replies
2
Views
243

1,128,136
Messages
5,628,911
Members
416,352
Latest member
Lunox01

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back