Formula for caluculating empty and text

Hi All,
I have to calculate a cell is having empty or not,if having it should not be completed.

if the cells is empty and not equal to Completed than 5 have to come in new cell or 0 have to come.

I'm writing Macro for this.Please help me to complete this task.

My code is
Sub ComplianceSolutionApprovalFormula()
Sheets("ComplianceReport").Select
Range("BN1").Value = "Solution Approval"
15]<>""Approved"",10,0),""NA"")"
Range("BN2").FormulaR1C1 = "=IIF(OR(ISBLANK(RC[-58])),IF(RC[-58]<>""Completed"",5,0),""NA"")"
End Sub

You formula is coming out

You formula is coming out as:

=IIF(OR(ISBLANK(RC[-58])),IF(RC[-58]<>"Completed",5,0),"NA")

I think what you want is:

=IF(AND(ISBLANK(RC[-58]),RC[-58]<>"Completed"),5,0)

There's no such thing as IIF in Excel formulas (IF does the same).

Chris