retrun blank if error

  • Thread starter Thread starter chegel
  • Start date Start date
C

chegel

I am trying to create a dual entry system, a1=b1, and b1=a1; if I
enter a value in either a1 or b1 it is copied to the other. Can I
program both to return a blank with the circular ref error. This
returns 0 not blank:for a1 =if(iserror(b1),"",b1) and for b1
=if(iserror(a1),"",a1)
 
I am confused.........easily done<g>

How do you enter a value in a cell that contains a formula?


Gord Dibben MS Excel MVP
 
Back
Top