Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Profile picture
AND function Excel
  United States
Moderator
0 Questions, 0 Answers
  Active since 08 December 2025
  Last activity one month ago

Scoold is a lightweight Q&A platform for teams and communities. Organize knowledge easily, and check BudgetExcel for free Excel templates.

budgetexcel.com/how-to-use-and-function-in-excel/

Reputation

10 + 10 this January

Badges 1

Nice Profile