2 IF(AND( statements

aecross

Using 2 IF(AND( formulas and i'm getting the #INVALID DATA TYPE error. When Scope Approved and Scope Requested are both checked, it should return "Committed". If Scope Approved is unchecked but Scope Requested is checked, it should return "Identified'.

=IF(AND([Scope Approved]@row = 1, [Scope Requested]@row = 1, "Committed", ""), IF(AND([Scope Approved]@row = 0, [Scope Requested]@row = 1, "Identified", "")))

Appreciate any help!

Paul Newcome

Try this:

=IF([Scope Requested]@row = 1, IF([Scope Approved]@row = 1, "Committed", "Identified"))

Paul Newcome

Try this:

=IF([Scope Requested]@row = 1, IF([Scope Approved]@row = 1, "Committed", "Identified"))

aecross

Thanks, @Paul Newcome; however, I don't want all the others to default to "Identified". It should only be identified if Scope Requested is checked. If neither Scope Approved nor Scope Requested is checked, it should be blank.

Paul Newcome

Yes. And that is how my formula would work. Have you plugged it in to see if it works how you expect it to?

aecross

Ahh, i'm sorry. Yes, that does work. Can you explain how that formula is set up?

Paul Newcome

It is taking advantage of how the IF statement works.

=IF(this is true, run this other IF statement)

If the first box is checked, if the second box is checked output "this", if the second box is not checked, output "that".