IF/AND Statement

Meredith Kay

Hello,

I am trying to write a formula where a box will be checked if a date listed is older than 10 days, AND if the status in another column is listed as "UNAPPROVED." I got the date part down already, but I'm having trouble adding in the second expression. Anyone have any ideas? This is what I have now:

=IF(AND([Entry/Routing Date]1 < TODAY(-10), 1), ([INV Status]="UNAPPROVED"))

It's coming back with the error message #UNPARSEABLE.

Thanks for your help!

Bassam Khalil

Hi @Meredith Kay

Hope you are fine, please try the following formula

=IF(AND([INV Status]@row = "UNAPPROVED", [Entry/Routing Date]@row < TODAY(-10)), 1)

Bassam Khalil

Hi @Meredith Kay

Hope you are fine, please try the following formula

=IF(AND([INV Status]@row = "UNAPPROVED", [Entry/Routing Date]@row < TODAY(-10)), 1)

Meredith Kay

Thank you so much! Works perfectly!

Bassam Khalil

@Meredith Kay

You are welcome, happy to help you