I am trying to write a formula that returns a value of blank if the contents
of field All Audit Compilation 1'!K3584 is either NA or P and the value of 1
if it is not NA or P. I started with =IF(ISNA('All Audit Compilation
1'!K3584),"") but still get the value of false if the field is blank and true
if it contains NA. I have the formula IF('All Audit Compilation
1'!K3585="P",€�€�,"1") which works fine on its own but do not know how to
combine the two formulas and have =IF(ISNA('All Audit Compilation
1'!K3584),"") return a value other than true or false