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]
--