# Help me with a formula pleeeeease!

#### londondan27

##### New Member
Hello,

I have column A which contains numbers, and column B needs to display YES if the number in column A is between 90 and 180, and NO if it's any other value.

I've got the formula for YES if it's over 90, but it's the bit about it also being below 180 which is hounding me.

Any advice would be very much appreciated.

Cheers,

Dan

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### PATSYS

##### Well-known Member
=IF(AND(A4>90,A4<180),"Yes","No")

#### londondan27

##### New Member
Superb!

That's brilliant. It works a treat. Thanks so much!

Dan

Replies
4
Views
758
Replies
4
Views
354
Replies
2
Views
815
Replies
5
Views
216
Replies
8
Views
648

1,190,913
Messages
5,983,539
Members
439,848
Latest member
timmyo

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