Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple Question
i want to get rid of the #NUM from my cells. Can i use conditional formatting? and what is the formula to use? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=475271 |
#2
|
|||
|
|||
Use IF(ISERROR(Formula),"",Formula) If you have multiple entries you could use a macro also. -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=475271 |
#3
|
|||
|
|||
Hi!
To use cf: Select the cell Conditional Formatting Formula is: =ISERROR(cell_reference) Set the font color to be the same as the background color Another way: Instead of using cf put an error trap in the formula that is returning the #NUM! error. =IF(ISERROR(your_formula)),"",your_formula)) Biff "cjjoo" wrote in message ... i want to get rid of the #NUM from my cells. Can i use conditional formatting? and what is the formula to use? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=475271 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple chart question | Excel Worksheet Functions | |||
Simple Date Display Question | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple question | Excel Discussion (Misc queries) | |||
Pivot Tables - "simple" question | Excel Discussion (Misc queries) |