This example looks in cell A1 in sheets 2,3,4:

=IF(Sheet2!A1*Sheet3!A1*Sheet4!A1=0,"Fail","Pass")

--
Gary's Student
gsnu200702


"JaB" wrote:

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