Jump to content

Advance find formula

Arun Rohila

Recommended Posts

Hopefully there's a better formula than I have.  I have a saved search to find any comic with the Condition being a CGC.  However, I can only do one for each CGC level, like 9 to 8 and 7 to 5, etc.
I would like a formula that would find all of the comics that I have in stock that are either CGC or CBCS regardless of grade (9.8 - 7.5 for example).
Here is the current formula that I have in the Advanced Formula to find only the CGC 9.8 to 9.0.  Any help would be greatly appreciated.
Items where: (I.[Condition] = "CGC 9.0" OR I.[Condition] = "CGC 9.2" OR I.[Condition] = "CGC 9.4" OR  I.[Condition] = "CGC 9.6" OR I.[Condition] = "CGC 9.8" ) and I.[QtyInStock] > 0
Order by: I.[Title]
Link to comment
Share on other sites

  • 3 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...