IF Formula question

[rjacmuto32]

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

 

[barry houdini]

Try something like

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