Posted to microsoft.public.excel.worksheet.functions
|
|
replace error with blank
Try these:
A1: =IF(B1=0,"",B1)
B1: =IF(A1=0,"",A1)
--
Biff
Microsoft Excel MVP
"chegel" wrote in message
...
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
|