With the cell containing the fomula selected, Insert, Name, Define, an
name the item.
Had you considered entering your formula into multiple helper columns
to assist you in that it would reduce the level of complexity and th
results from various stages of calculation could be checked. Thes
helper columns can remain hidden once the formula is working.
Micayla said:
i have a massive formula which i want to have a name for but i cant cop
it
into the 'refers to' field. how do i put the formulas in for naming?