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

Add % symbol to the end of the formula and shorten to 1 symbol after comma:…

  1. User

    Add % symbol to the end of the formula and shorten to 1 symbol after comma: =sum((E5+(E3/2))/(E7+(E3/2))*100)

  2. Assistant

    To add the % symbol and shorten the result to 1 decimal place, you can use the TEXT function combined with your formula.

    Here is the modified formula:

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

    Explanation:

    • SUM(...) stays as in your original.
    • TEXT(..., "0.0") formats the number with 1 decimal place.
    • & "%" appends the % symbol.

    Alternatively, if you want your formula as a percentage in Excel (so Excel displays it as a percentage rather than text), use:

    =ROUND((E5+(E3/2))/(E7+(E3/2))*100,1) & "%"
    

    This rounds the result to 1 decimal and appends the % sign as text.

    If you want Excel to treat this as a numeric percentage value (and format the cell with %), just use:

    =ROUND((E5+(E3/2))/(E7+(E3/2)), 3)
    

    And then format the cell with % and 1 decimal place using cell formatting options.

    Let me know which approach fits your need!