Thread: replace error with blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chegel chegel is offline
external usenet poster
  
Posts: 5
Default replace error with blank
I am creating a form to allow input from either of 2 seperate cells.
Example:a1=b1, b1=a1 , when entering in either cell it is copied to the
other. I need to suppres the circular reference error in both cells with a
blank ("").
I get 0 instead of blanks with the following:
[a1] =IF(ISERROR(B1),"",B1)
[b1] =IF(ISERROR(A1),"",A1)
--
Chris

Reply With QuoteReply With Quote