Apr 19 2019 08:56 AM
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.
Apr 19 2019 09:57 AM
@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")