AND formula

[Jafferi]

Below is my example. I am not able to find any solution for AND fomula. My
problem is in cell A, the figure entered is 42. I want this figure to show in
Cell D. in other words, how can I create a fomula that determine if cell A is
between 31 and 45, mark X (in cell D)



A B C D E F
-------------|---------|--------|---------|--------|----------
| <15 | 16-30 | 31-45 | 46-60 | >1
-------------|---------|--------|---------|--------|----------
42 X
-------------|---------|--------|---------|--------|----------
10 X

 

[Gary''s Student]

=IF(AND(A2>30,A2<46),"X","")

 

[Eduardo]

Hi,
in cell D enter
=if(and(A1>30,A1<46),"x","")