MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Derek Dobson on January 15, 2002 4:27 PM

How do I get a formula to ignore a cell that has a word in it and display the word instead of #value ?

Posted by Aladin Akyurek on January 15, 2002 4:32 PM

Derek --

Not sure I understand.

Are you referring to the #VALUE! error?