View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
special special is offline
external usenet poster
 
Posts: 1
Default 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