Excel will allow you to use alt-enters in your formulas--don't put them inside
strings (between ""'s).

And it forgives extra spaces between arguments.

I could use:
=IF($B26="",
"",
ROUNDUP(
INDEX(
Refs!I:I,MATCH(
$M26,Refs!H:H,0))*K26,0))


(Yep, I had difficulty seeing what you wanted.)

And remember that in xl97-xl2003, your formulas cannot exceed 1024 characters
(when measured in R1C1 reference style.)



DasVimble wrote:

With my poor vision I have a hard time seeing the structure in a formula I am
writing or modifying. The built-in tools are useful, but I would like an
option to toggle the formula from this:

=IF($B26="","",ROUNDUP(INDEX(Refs!I:I,MATCH($M26,R efs!H:H,0))*K26,0))

to something like this:

=IF(.............................................. .................................................. .............................)

$B26="","",ROUNDUP(............................... .........................................*K26,0)

INDEX(............................................ ...............)

Refs!I:I,MATCH(.............................)

$M26,Refs!H:H,0

{difficult to format here without a monospace font}

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson