Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Elegant Formulas
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[i]].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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Elegant Formulas
littleredhairedgirl wrote:[i]
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Elegant Formulas
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 "smartin" wrote: [i] littleredhairedgirl wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Elegant solution for two comparisons | Excel Discussion (Misc queries) | |||
Is there an elegant way? | Excel Discussion (Misc queries) | |||
Is there an elegant solution to this table? | Excel Discussion (Misc queries) | |||
More elegant way to do IF () | Excel Worksheet Functions | |||
More elegant method? | Excel Worksheet Functions |