Member formula still calculating when when "IF" is false

Summary:

Content (required):

We have a formula that is supposed to check the employee status, and if active, calculate the 401. However, we have noticed that that it continues to calculate when an employee status is removed/missing. It doesn't seem to be happening on other accounts that check status. However, those are simple IF Status is Active, then put in salary, Else #missing.

Is there something that needs to be added/changed in the formula below?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

/* Check for Active status */