Thread: I want to return the #VALUE! as a blank cell.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kgb1953 kgb1953 is offline
external usenet poster
  
Posts: 1
Default I want to return the #VALUE! as a blank cell.
I am creating an electronic order form and need to show #VALUE! as a blank
cell. When using =IF(ISERROR(A2)="TRUE"," ",<REST OF FORMULA), I can no
longer total that column. Any suggestions?
Reply With QuoteReply With Quote