Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ignoring text data in a cell when summing values in the same cell | New Users to Excel | |||
Ignoring non-filled formulas in average | Excel Discussion (Misc queries) | |||
Excel ignoring previously entered formulas | Excel Worksheet Functions | |||
Ignoring Formulas within cells | Excel Worksheet Functions | |||
Ignoring formulas in Custom Headers | Excel Discussion (Misc queries) |