Raising the Flag

K@te

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

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

Thank you, that was a big help. 

You are very appreciated