trying to get rid of formula error messages

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?

Originally Posted by turbo90talon

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?

Make your formulas like this

=IF(ISERROR(your_formula),"",your_formula)