How do you return the word “High” if a value in A2 is in the top 10% of a list in…
- User
How do you return the word “High” if a value in A2 is in the top 10% of a list in A2:A100? Use a formula-based logic.
Assistant
=IF(PERCENTRANK.INC(A2:A100,A2)>=0.9,"High","")Explanation:
PERCENTRANK.INC(A2:A100,A2)calculates the relative rank of the value inA2within the rangeA2:A100as a percentage (0 to 1).- If the rank is greater than or equal to 0.9 (top 10%), the formula returns
"High". Otherwise, it returns an empty string ("").
This formula dynamically evaluates whether the value in
A2is in the top 10% of the list.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.