B

#### brian.baker13

I have a formula

='[Labour Variance Report wk01.xls]Summary'!$N$55+'[Labour Variance

Report wk01.xls]Summary'!$N$56='[Labour Variance Report

wk01.xls]Summary'!$N$75+'[Labour Variance Report wk01.xls]Summary'!$N

$81+'[Labour Variance Report wk01.xls]Summary'!$N$82

some of the referenced cells have a #value! error so I get an error in

the returned cell. i want to replace any #value! errors in the above

formula with a 0. How do I do this please?

Thanks

Brian