Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

@ERR in Quattro spreadsheet

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?
0
PaBirds
Asked:
PaBirds
  • 2
2 Solutions
 
aflockhartCommented:
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")
0
 
aflockhartCommented:
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now