Function AI.CHOICE
The AI.CHOICE function selects the most closely matching value from a given list of choices based on the provided data. Simply specify the cell or range with the data and the list of choices.
Examples
Categorizing Customer Reviews
=AI.CHOICE("Great quality and fast shipping. Very satisfied.", "Positive, Neutral, Negative")
Classifying Job Applicants by Department
=AI.CHOICE("Experience in managing financial accounts and budgeting.", {"Finance", "Marketing", "HR", "IT", "Sales"})
Identifying Types of Animals
=AI.CHOICE("Elephant", "Mammal, Bird, Reptile, Amphibian, Fish")
Categorizing Social Media Posts by Topic
=AI.CHOICE("Just attended an amazing technology conference!", {"Technology", "Travel", "Food", "Fitness", "Fashion"})
Classifying Types of Artwork
=AI.CHOICE("A detailed and lifelike portrait painted in oils.", {"Portrait", "Landscape", "Abstract", "Still Life", "Sculpture"})
Syntax
AI.CHOICE(value, choices)
| Argument name | Description |
|---|---|
| value | Cell or range containing data or text. |
| choices | List of choices. Can be reference to a cell range or passed directly as a function argument. |