Skip to content
TheChatArchiveThe Chat Archive
gpt-4.1-mini-2025-04-14· OpenAIAi2 WildChat-4.8M (AI2)

fix formula =TEXT(SUM(E6/(E7+(E3/2))*100, "0.0") & "%")

  1. User

    fix formula =TEXT(SUM(E6/(E7+(E3/2))*100, "0.0") & "%")

  2. Assistant

    Your formula has a few issues with parentheses and the placement of the TEXT function parameters. Here's the corrected formula:

    =TEXT((E6/(E7+(E3/2))*100), "0.0") & "%"
    

    Explanation:

    • SUM is not needed since you are not summing a range but performing a single calculation.
    • The division and multiplication need to be enclosed properly for priority.
    • TEXT needs two arguments: the number to format, and the format string.
    • After formatting, you concatenate the % symbol as text.

    Let me know if you want it as a percentage number (formatted as a percentage) or as text with % symbol manually appended!