On Nov 22, 1:45*pm, 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

Hi
another suggestion might be to use a concatenator such as the
ampersand symbol.

example....
="MyTag " & (10*$C$13)+(17*$C$17)+(20*$C$14)

be sure to use spaces Between the quotes as seperators.

Here is a formula i use in one of my files....
=SUM(BP355:BP404)&" / "&COUNT(BP355:BP404)&" =
"&ROUND(SUM(BP355:BP404)/COUNT(BP355:BP404),2)

it's actually 3 formula in one and shows all 3 results in the same
cell.
just may sure all text is in quotes and ampersands connecting
everything.

Regards
FSt1