gpt-4.1-mini-2025-04-14· OpenAI
WildChat-4.8M (AI2)
fix formula =TEXT(SUM(E6/(E7+(E3/2))*100, "0.0") & "%")
- User
fix formula =TEXT(SUM(E6/(E7+(E3/2))*100, "0.0") & "%")
- Assistant
Your formula has a few issues with parentheses and the placement of the
TEXTfunction parameters. Here's the corrected formula:=TEXT((E6/(E7+(E3/2))*100), "0.0") & "%"Explanation:
SUMis 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.
TEXTneeds 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!