o3-mini· OpenAI LMArena Human Preference 140K
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
You can use the
PERCENTILEfunction combined with anIFstatement. For example, to return "High" in cell B2 if A2 is in the top 10% of the range A2:A100, use:=IF(A2>=PERCENTILE($A$2:$A$100,0.9), "High", "")This formula checks if A2 is greater than or equal to the 90th percentile of the list, and if so, returns "High".
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.