Thread: define formula components as text

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

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