#### tony_d

##### Board Regular
In A40 I have this formula =IF(AND(A38>=50000,A38<=99999),A38,"")I now would like in B2 to set a flag if the criteria is met i.e between 50k and 9999
Something like this =IF(A40>=50000and <=99999,"BAND B ","")

But cannot find the correct formula

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### Richard Schollar

##### MrExcel MVP

=IF(A40="","","BAND B ")

Regards

Richard

#### Scott Huish

##### MrExcel MVP
=IF(A38=A40,"B AND B ","")

#### tony_d

##### Board Regular
Superb guys
Y do I always go the long way round ?????
thanks

Replies
2
Views
258
Replies
1
Views
146
Replies
4
Views
101
Replies
4
Views
264
Replies
8
Views
225

1,195,951
Messages
6,012,495
Members
441,702
Latest member
chacham

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