Formula editor

[Royville]

Hi Folks,

Does any one know of a good formula editor for excel. I find I can get very confused when trying to 'sus' out the varying levels of parentheses of some of the formulae in excel.

Cheers
Royville

[osknows]

In Excel you can use SPACES and ALT+ENTER for line breaks to split out complex formulae

Eg instead of this in a cell

Code: Select all

=IF(A1=TRUE,"Do This", IF(B1=FALSE,"Do That", "Else do Something else"))

it can look like this

Code: Select all

=IF(A1=TRUE,"Do This",
      IF(B1=FALSE,"Do That",
      "Else do Something else"))

[Royville]

Thanks for that Os,

Sorry for the delay - not been around for a while.
So I gather there is nothing around that will do the job.
Your method will certainly help (thanks) but I was wondering if there was anything which say highlighted brackets and that sort of thing.

Kind regards
Royville.

[osknows]

You could give this a try http://www.dailydoseofexcel.com/archive ... n-notepad/