Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

array formula question

Posted by Andonny on June 09, 2001 8:05 PM

Hi,
I would like to know how I am able to see what numbers an array formula is
calculating. This is the formula I array entered and I know what it does but
in order to work out other formulas it would be nice to see what numbers are
in the array to debug it.
{=SUM(A1:B3*D1:E3)}

Thanks for your help
Andonny

Re: array formula question

Posted by Aladin Akyurek on June 09, 2001 11:31 PM

Andonny

Go to the formula bar, just select the part you're interested in, and hit F9. When you'rr ready, hit ESCAPE, otherwise you loose the formula.

Aladin

This is a great tip!

Posted by IML on June 11, 2001 7:27 AM

Aladin told me about this a few months ago, and it has helped my pathetic array formulas tremendously.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.