gpt-4.1-mini-2025-04-14· OpenAI
WildChat-4.8M (AI2)
Add % symbol to the end of the formula and shorten to 1 symbol after comma:…
- User
Add % symbol to the end of the formula and shorten to 1 symbol after comma: =sum((E5+(E3/2))/(E7+(E3/2))*100)
- Assistant
To add the % symbol and shorten the result to 1 decimal place, you can use the
TEXTfunction 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!