Skip to content
The Chat Archive
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…

  1. 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.

  2. Assistant

    You can use the PERCENTILE function combined with an IF statement. 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".

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.