You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Member formula still calculating when when "IF" is false

Received Response
edited Apr 17, 2023 6:57PM in Planning 2 comments


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 */

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!