# IF Formula question

#### rjacmuto32

##### Board Regular
I have a cell with a number (A3) and I want to put in a formula in 2 cells. In one cell I want If A3 is between 100-200 to display anything and in the other cell I want the IF A3 is between 201-500.

How do I put a formula in for those.

I can do a simple one like IF less then 100. But I don't know how to factor in the 2parts like between 100 and 200

Thanks

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

#### barry houdini

##### MrExcel MVP
Try something like

=IF(AND(A3>=100,A3<200),A3,"")

Replies
11
Views
116
Replies
3
Views
54
Replies
3
Views
48
Replies
6
Views
73
Replies
2
Views
123

1,109,368
Messages
5,528,274
Members
409,813
Latest member
robyrux

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...