Good morning

Im trying to create a formula in sheet 1 that looks at values in sheets 2, 3
and 4 and searches for a 0. If it finds a 0 I want it to return a value of
'Fail', if it doesnt I want it to return a value of 'Pass'.

As it stands I just keep getting 'VALUE' returned and I think the problem Im
having maybe related to that fact that Im trying to make this work over
various sheets.

Any ideas?

Thanks