avoiding a #value! return

[brian.baker13]

Hi

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

 

[Bob Phillips]

=IF(ISERROR(formula),0,formula)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[brian.baker13]

=IF(ISERROR(formula),0,formula)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Hi

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?

Brian- Hide quoted text -

- Show quoted text -

I have applied the formula as above which works a treat.

Ta

Brian