Skip to content
TheChatArchiveThe Chat Archive
Qwenqwen-max-2025-01-25· Alibaba (Qwen)Hugging Face 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…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with o3-mini’s answer.
  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. Qwen Assistant

    =IF(PERCENTRANK.INC(A2:A100,A2)>=0.9,"High","")

    Explanation:

    • PERCENTRANK.INC(A2:A100,A2) calculates the relative rank of the value in A2 within the range A2:A100 as 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 A2 is in the top 10% of the list.

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

Identical first prompt