Thank You, this solved my problem.

"Rick Rothstein (MVP - VB)" wrote:

Current Formula
=IF(($G9="Full")*AND($H9="Perm"),IF(OR($I9={"Activ e","Detail In"}),1,0))

Your formula above is missing the FALSE condition for the first IF
function call.... I think adding ',0' (comma-zero without the apostrophes)
will do what you want.

I meant to include... "adding it in front of the **last** closing
parenthesis".

Rick