How do I do Between in a function

Mindy.cordova89921

I have a status bar and I want to do between 1-25 = Quarter but I don't know how to do it. I think it's an IF(And(but i'm not sure the syntax. Thanks!

Kelly Moore

Hey @Mindy.cordova89921

This syntax should work for you. Be sure to edit the column name to match your actual column name

=IF(AND([your column]@row >= 1, [your column]@row <= 25), "Quarter")

Kelly

Mike TV

Example sheet:

Status formula:

=IF(AND([Column2]@row > 0, [Column2]@row < 26), "Quarter", IF(AND([Column2]@row > 25, [Column2]@row < 51), "Half", ""))

Kelly Moore

Hey @Mindy.cordova89921

This syntax should work for you. Be sure to edit the column name to match your actual column name

=IF(AND([your column]@row >= 1, [your column]@row <= 25), "Quarter")

Kelly

Mike TV

Example sheet:

Status formula:

=IF(AND([Column2]@row > 0, [Column2]@row < 26), "Quarter", IF(AND([Column2]@row > 25, [Column2]@row < 51), "Half", ""))

Mindy.cordova89921

Thank you both!!!