LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ignoring text data in a cell when summing values in the same cell FM New Users to Excel 2 February 24th 10 02:51 AM
Ignoring non-filled formulas in average Laurizio Excel Discussion (Misc queries) 6 January 26th 09 01:44 PM
Excel ignoring previously entered formulas mijoh Excel Worksheet Functions 3 April 24th 07 06:38 PM
Ignoring Formulas within cells jimswinder Excel Worksheet Functions 8 July 21st 06 02:52 PM
Ignoring formulas in Custom Headers Mizuchi Excel Discussion (Misc queries) 3 April 1st 05 05:19 AM


All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"