IF and AND functions on Excel

[mt219]

How do I write an IF statement that makes sure a cell's value is between two numbers.

For instance:

Check whether 0.9 exceeds a range between 0.2 and -0.2.

If it is larger than this range, then keep I would like to keep this number.
If it is smaller and falls between this range, I would like turn it into a 0.

Any help would be appreciated

[alansidman]

If it is smaller and falls between this range, I would like turn it into a 0.

Are you looking for smaller than -.2 or between the range .2 and -.2

This statement is confusing.

[mt219]

Apologies, I want to check whether a number falls between -0.2 and 0.2.

[alansidman]

Assume your test number is in A1, then in A2 =if(and(A1>-.2,A1<.2),0,A1)

This will return zero if the value in A1 is between your criteria. It will return the value in A1 for all other results.