Raising the Flag

K@te · 11/27/18

I want to raise the flag when I have a number in a cell that is >=0 but <4. how do I write a formula that will raise the flag and not include the blanks

Brian W · 11/27/18

I think you want something like this:

=IF(ISBLANK([Column Name]@row), 0, IF(AND([Column Name]@row >= 0, [Column Name]@row < 4), 1, 0))

Make sure the column you put it in is a Flag type, and change Column Name to the column you are analyzing.

K@te · 12/03/18

Thank you, that was a big help.

You are very appreciated

Raising the Flag

Comments

Categories