Calcualted column is returning "#Name?"

Question

I have the following formula for a single line of text Calculated column named ShowInApp:

IF(OR(Status="Inactive",ISBLANK(Status)),"Hide",IF(FIND("Pending",[Category]),"Hide",IF(FIND("Monitoring And Evaluation Plan",[Category]),"Hide","Show")))

But on some cases I will get #Name? or #VALUE!, as follow:

Any Advice? Thanks

In short I want to set the calculated column to Hide, if any of the following is true:

1. Status is blank
2. Status = inactive
3. Category contain the word Pending
4. Category contain "Monitoring And Evaluation Plan"

Else to set the calculated column to Show.

Answer 1

Try using this formula:

=IF(
    OR(
        [Status] = "Inactive",
        ISBLANK([Status])
    ),
    "Hide",
    IF(
        NOT(ISERROR(FIND("Pending", [Category]))),
        "Hide",
        IF(
            NOT(ISERROR(FIND("Monitoring And Evaluation Plan", [Category]))), "Hide", "Show"
        )
    )
)

Documentation: Examples of common formulas in lists