Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the fx key to debug formulas
I'm working with the SUMPRODUCT function.
If I highlight a cell containing a SUMPRODUCT formula, & press the formula (paste function) key 'fx', it shows me the arrays I've entered. Now, it also shows me the first array RESULTS to the right of each formula, like ={0;0;1;0;0; ... and so on. This is very useful. Is there a debug feature, or some way, for me to see more of the array results? Thanks, Bill. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the fx key to debug formulas
Hi!
You can select the cell with the formula, then, in the formula bar use your mouse to highlight the expressions you want to evaluate then hit function key F9. There's a limit as to how many array elements it will display, though. I'm not sure what that limit is but I just tried it on an array of 2 columns by 250 rows and it kicked up a message: Formula too long. Another option if you use Excel 2002 and up....... Select the cell with the formula. Goto ToolsFormula AuditingEvaluate Formula. This allows you to step through the formula exactly as Excel does. I use this a lot. It's great for finding problems. One thing, however, at least it happens to me, if you evaluate certain types of "complex" array formulas it causes Excel to crash. I can crash Excel at will! Biff "Bill" wrote in message ... I'm working with the SUMPRODUCT function. If I highlight a cell containing a SUMPRODUCT formula, & press the formula (paste function) key 'fx', it shows me the arrays I've entered. Now, it also shows me the first array RESULTS to the right of each formula, like ={0;0;1;0;0; ... and so on. This is very useful. Is there a debug feature, or some way, for me to see more of the array results? Thanks, Bill. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |