# If/or/and

#### kizzie37

##### Well-known Member
Ok, so i have a slightly complex If/OR/AND that I cant get to work

If the value in g3 is = to 1 OR G3 between 2 and 10), then yes, or No

=IF(AND(G3="20700",(IF(OR(AH8>=60200,AH8<=70855),"yes","no")),"yes","no")

I think this is close, but it is missing ",

can anyone help with the correct formula string?

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

=IF(OR(G3="20700",(IF(OR(G38>=60200,G3<=70855)),"yes","no")))

Hi,

Try,

=IF(OR(G3="20700",G38>=60200,G3<=70855),"yes","no")

I think the "20700" should be 20700.

Also, in first post you said

If the value in g3 is = to 1 OR G3 between 2 and 10), then yes, or No

The actual formula says totally different thing.

Jai

OK, so what is correct bascically I have to match a cell to either single numbers, or in a range of numbers, eg:

G3 is equal to 1 and h3 between 2 and 10, then Yes

Replies
3
Views
218
Replies
3
Views
232
Replies
0
Views
112
Replies
2
Views
211
Replies
3
Views
403

1,196,502
Messages
6,015,583
Members
441,902
Latest member
alhaste

### 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