Using the if function

Copper Contributor

Hello, I am not good with the if function.  How do I use the if function when I want to show the following.

1-30 days, I go that one working

31-60 days, I cannot get this function to work.  How do I go write this on the if function where it should be greater than 31 days, but less than 60 days. 

1 Reply

@Tommentions , partly depends on what your calculations are. Some of variants could be

=IF(A1>60,"one",IF(A1>30,"two","three"))
=LOOKUP(A1,{0,31,60},{"one","two","three"})
=IF(AND(A1>30,A1<=60),"one","two")