Forum Discussion

Tommentions's avatar
Tommentions
Copper Contributor
Apr 19, 2019

Using the if function

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 ...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 19, 2019

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")