 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007retrun blank if error
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 >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)
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.