Have you thought of naming the cells?

Name the cells then refer to those names in the formulas.

=(10*zebras)+(17*lions)+(20*wombats)

OR use the N function to add descriptions to the formula

=(10*$C$13)+(17*$C$17)+(20*$C$14)+N("zebras + lions + wombats")


Gord


On Tue, 22 Nov 2011 12:45:47 -0600, special
wrote:

Hello,
Is there a way in Excel to write text in a cell which will be ignored in a
formula. For example I have multiple formulas such as

=(10*$C$13)+(17*$C$17)+(20*$C$14)

I would like to have a tag as to what $C$13 actually is. That information is
listed in B13 so it would be nice to just reference that cell as text, and
have
it be ignored by the equation. However, I would still be happy if I could
just
write in what C13 is. Unfortunately most of my equations are too complicated
to have a built in function in Excel.
Thanks, Ed