Flag #CIRCULAR error

Adarian Searcy

Hi,

I am attempting to create a formula that will check the At Risk (Flu) if it meets certain criteria.

If Flu Compliance Status is "Non-compliant" and Level of Flu is grater than 5% check At Risk (Flu).

The formula I created with a #CIRCULAR error is listed below.

=IF(AND([Flu Compliance Status]@row = "Non-compliant", VALUE([Level of Flu]@row) > 5), [At Risk (Flu)]@row, "")😫

Jennifer Kurtz

Hey there! You don't need to reference the column where you're putting the formula in the "value if true" part of the formula - i.e., [At Risk (Flu)]

I think that's why you're getting the circular error.

Hope that helps!

Adarian Searcy

Hi Jennifer,

Thanks for the assistance. Now I have a #UNPARSEABLE error. I will continue to work on it.

Best,

AD

Jennifer Kurtz

I suspect the UNPARSEABLE is related to the VALUE function with the "Level of Flu" column. Is that a drop down column? I think you'll need to use a different statement there. If it's a drop down, something like [Level of Flu]@row= "<6% to >9%"

(Also, is that range option possibly supposed to be greater than 6% to less than 9%? >6% to <9%?)

Good luck!