If Formula - Greater than 30 but less than 60

[JUDY MCCARTNEY]

Hi - I am trying to create an if formula to trend a mountain of data I have.

Clients travel so many days after booking with us and I am trying to trend this into months.
I want
12 days to appear in less than 1month column
36 days to appear in 2 month column
61 days to appear in 3 month column


The formula I want to enter is
If (A1<30,1,0) so this correctly gives me a 1 in 1 month column

Now I want to get 36 days to appear in 2 month column only
if (a1<60>30,1,0) but I get an error message

Please help as my head is so sore now - I though this would be simple.

 

[philwojo]

Try:

if(and(a1<60,a1>30),1,0)

 

[JUDY MCCARTNEY]

This worked - you are wonderful