View Single Post
  #1   Report Post  
Harry Garrett
 
Posts: n/a
Default Text and the #VALUE error

Is there a way that you can use text in a cell that is part of a formula
such that the formula returns 0 instead of a "#VALUE" error?

I would like to be able to insert memos for extraordinary events which would
be displayed with the rest of the sheet.

Thanks

Harry