IF(AND formula to be used with Star Symbol

Sharon Castiglia

Hello,

I have an On Time column that when conditions are met populates a colored star. If the store opens after 6 am the star does not color. If the store opens between the hours of midnight and 6 am the star is colored. I keep getting #UNPARSABLE error (the [Value_if_false] highlighted in yellow when i go into the formula.

=IF([Store Open HR]@row = 0, false, IF(AND([Store Open HR]@row > 6, [Store Open HR]@row <12, [Store Open AM/PM] @row ="A"), false, true)

Not sure how to fix this

Thank you in advance

Sharon

Genevieve P.

Hi @Sharon Castiglia

You have both an AND and an OR function embedded in your IF statement, but you don't close off the OR statement after the Store Open HR column:

=IF(AND(OR([Store Open HR]@row <=6, [Store Open HR]@row =12), [Store Open AM/PM]@row ="A"), 1, 0)

^ That's likely the cause for the error, you're missing a closing parenthesis after the 12.

Now, this is only looking for if the cell has exactly the letter "A" in it, since you put that in quotes. Does the Store Open AM/PM have exactly "A", or are you looking to see if it contains the letter A?

If the column as "AM" instead of A, you can add in the CONTAINS function as well:

=IF(AND(OR([Store Open HR]@row <= 6, [Store Open HR]@row = 12), CONTAINS("A", [Store Open AM/PM]@row)), 1, 0)

Let me know if this makes sense or if you need any further help!

Cheers,

Genevieve

Gil Nash

Sharon Castiglia

I am still getting an unparsable error (Incorrect Argument Set).

=IF(AND(OR([Store Open HR]@row <=6, [Store Open HR]@row =12, [Store Open AM/PM]@row ="A"), 1, 0)

Could it have something to do with the "A" as opposed to "AM". I have to use the "A" designation for time formulas

Genevieve P.

Hi @Sharon Castiglia

You have both an AND and an OR function embedded in your IF statement, but you don't close off the OR statement after the Store Open HR column:

=IF(AND(OR([Store Open HR]@row <=6, [Store Open HR]@row =12), [Store Open AM/PM]@row ="A"), 1, 0)

^ That's likely the cause for the error, you're missing a closing parenthesis after the 12.

Now, this is only looking for if the cell has exactly the letter "A" in it, since you put that in quotes. Does the Store Open AM/PM have exactly "A", or are you looking to see if it contains the letter A?

If the column as "AM" instead of A, you can add in the CONTAINS function as well:

=IF(AND(OR([Store Open HR]@row <= 6, [Store Open HR]@row = 12), CONTAINS("A", [Store Open AM/PM]@row)), 1, 0)

Let me know if this makes sense or if you need any further help!

Cheers,

Genevieve

Sharon Castiglia

Well Genevieve,

You are a gem. Worked FABULOUSLY. Such a silly error on my part. Learned something new too. You get 👍️👍️👍️👍️👍️

Genevieve P.

Hi Sharon,

Haha no problem at all!! I'm glad it works for you 😊