@ERR in Quattro spreadsheet

Posted on 2012-08-27
Last Modified: 2012-08-28
I am trying to evaluate an ERR response in an If function in Quattro Pro.
If the result of the @Find function is ERR, then I want "A", else "B."

I tried both  @IF(@FIND("Z",A1,0)="ERR","A","B")  and @IF(@FIND("Z",A1,0)=@ERR,"A","B")

Both return ERR in the cell if the character (Z) is not found.

I also tried @IF(@FIND("Z",A1,0)<0","A","B")  since @Find returns the position of the character.

That did not work either.

So, how can I get the @If function to recognize the ERR response from the @Find?
Question by:PaBirds
    LVL 17

    Accepted Solution

    Haven't used Quattro Pro for a very long time but I think it contains an @iserr function that you can use to check for ERR responses

    Would be used something like
    @if (@iserr(@FIND("Z",A1,0)) ,"A","B")
    LVL 17

    Assisted Solution

    And the reason your original versions wouldn't work is because the ERR that is returned from the FIND function is not a string containing the letters E,R,R ; but is a special error value.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now