Iserrfunction

D

diannerabkin

Spreadsheet shows 3 columns for each month then quarterly totals for
each quarter


Budget Actual Variance

Budget reg in put as Salarys = 50,000 with no formulas
Actual refers to input on another worksheet formula below
Variance obviously the difference. a-b = c simple

Formula please to eliminate the error message for blank cells where
there are no budget numbers when they actually need to be blank.


Here is the formula for the Actual column =SUMIF(January!$A$16:$A
$955,A6,January!$E$16:$E$955)+SUMIF(January!$A$5:$A$13,A6,January!$B
$5:$B$13)+SUMIF(January!$F$5:$F$13,A6,January!$G$5:$G$13)
Would like to be able to use iserr or something else to determine if
the cell has an error.

Lots of pages to this workbook...appreciate any advise
 
D

Dave F

It sounds like you want to replace errors with blanks in formula results. If
that is correct, then the way to modify your formula is as follows:
=IF(ISERROR([your formula]),"",[your formula])

Dave
 
Top