Ignoring text in cell formulas
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
|