in my workbook one of the sheets pulls info from other sheets in the workbook. if the other sheets have blanks on them it shows up on the other sheet as error msg. how do i get rid of these error messages and make those spots just blank cells?
in my workbook one of the sheets pulls info from other sheets in the workbook. if the other sheets have blanks on them it shows up on the other sheet as error msg. how do i get rid of these error messages and make those spots just blank cells?
Last edited by turbo90talon; 10-19-2007 at 10:55 PM.
Make your formulas like thisOriginally Posted by turbo90talon
=IF(ISERROR(your_formula),"",your_formula)
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks