| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| replace - by blank, keep 0 in phonenumber | Excel Worksheet Functions | |||
| Replace cells with blank | Excel Worksheet Functions | |||
| Replace cells with blank | Excel Worksheet Functions | |||
| replace N/A by a blank | Excel Discussion (Misc queries) | |||
Threaded Mode
