define formula components as text

[Elaudu]

hi all

i have some very long and complex formulas in my Excel workbook and it's extremely difficult to track and debug some of them.
is there a way to define components of these formulas, such as "VLOOKUP(**,***,**,0) as text so that they appear as text in the formula bar but still serve their purpose?

thanks

[martindwilson]

you can name the ranges
and name cells with formulas in them for use in other formulas
eg
in a1
=if(b1=0,2,4) then name the cell say myformula
then in another cell put = 24*myformula then when b1 =0 it will return 48 else 96