Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Allow formulas to be formatted and editted like code in the formula dialog box

When writing complex formulas, it is very difficult to troubleshoot errors with in-line formats and although I can 'simulate' writing the formula like code in the formula dialog box, it is very cumbersome as it doesn't treat 'enter' as a next line and 'tab' as a tab. Also, when using this format in the current version, selecting a formula part and clicking on the fx doesn't show the values, only blanks. A sample is attached showing the format. Would it be possible to setup the formula dialog box to support a more coding IDE model?

=IFERROR(
SUMIFS(
tblBS[Avg],
tblBS[Month],
[@Month]
)
/COUNTIFS(
tblBS[Month],
[@Month],
tblBS[Avg],">0"
),
"")

5 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Jeffery Teall shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base