Search the Community
Showing results for tags 'formula'.
Found 1 result
Advance find formula
Arun Rohila posted a topic in Tech SupportHopefully 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] --