View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Recognizing an Unstable Result

In Column "B" I have a list of results. Some of them have the result of
"#VALUE!".
I would like these cells to be represented in Column "C" with the result of
"0". What IF statement correctly tests for cells which have "#VALUE!" in them?
--
Ken