Using =IF(AND) formula

Lindsay Scarey

Hello,

I'm trying to create a sheet summary formula that will return a "1" result if the following criteria are met: 1) the Sheet Summary field "Application Status" is showing "APPS ON HAND", and 2) the date in the sheet summary field "Oldest App on Hand" is more than five days prior to the current date. Otherwise, I want to result to be "0"

Here is my current formula and I am getting an #INCORRECT ARGUMENT error

=IF(AND([Application Status]# = "APPS ON HAND", [Oldest App on Hand]# < TODAY() - 5, 1, 0))

Thank you!

KPH

Hi

You have the closing parenthesis for the AND after the values to return for the IF. If you move it to here, you should be fine:

=IF(AND([Application Status]# = "APPS ON HAND", [Oldest App on Hand]# < TODAY() - 5), 1, 0)

KPH

Hi

You have the closing parenthesis for the AND after the values to return for the IF. If you move it to here, you should be fine:

=IF(AND([Application Status]# = "APPS ON HAND", [Oldest App on Hand]# < TODAY() - 5), 1, 0)

Lindsay Scarey

Awesome, thank you! I knew it had to be some little mistake like that. It's working now!

KPH

Great news!