Elegant Formulas

[littleredhairedgirl]

I use Notepad++ that allows a more clear (elegant) way to edit/
visualize script like this

function changeImages() {
if (document.images) {
for (var i=0; i<changeImages.arguments.length; i+=2) {
document[changeImages.arguments].src = eval
(changeImages.arguments[i+1] + ".src");
}
}
}
// END -->

If I have a excel formula like
=ISNUMBER(FIND(LEFT(B2,1), "AWFUY"))



I can use ALT-Enter to place breaks in the cell to allow
=ISNUMBER(
FIND(
LEFT(B2,1), "AWFUY")
)


Anyone know of a editor that knows Excel?

 

[Shane Devenshire]

Hi,

Of course the key reason to evaluate the formula in Excel is that you can
evaluate it piece by piece on the Formula Bar or in the cell by using F9.

In addition you can use the Tools, Formula Auditing, Evaluate Formula
command. Although I much prefer the flexibility of F9.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

I use Notepad++ that allows a more clear (elegant) way to edit/
visualize script like this

function changeImages() {
if (document.images) {
for (var i=0; i<changeImages.arguments.length; i+=2) {
document[changeImages.arguments].src = eval
(changeImages.arguments[i+1] + ".src");
}
}
}
// END -->

If I have a excel formula like
=ISNUMBER(FIND(LEFT(B2,1), "AWFUY"))



I can use ALT-Enter to place breaks in the cell to allow
=ISNUMBER(
FIND(
LEFT(B2,1), "AWFUY")
)


Anyone know of a editor that knows Excel?

FWIW I sometimes debug Excel formulae using the SQL language editor in
Notepad++. It does not recognize most Excel keywords but it nicely
parses parentheses, text, and such.

N++ will let you create your own keyword lists if you are so inclined.