IF formula over multiple sheets
 

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

IF formula over multiple sheets
 

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

IF formula over multiple sheets
 

Why not tell us the formula you're trying to use?
--
David Biddulph

"JaB" wrote in message
...
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

IF formula over multiple sheets
 

Well, i thought the easiest approach would be to name the cells in the sheets
(as they do not run sequentially). So my formula currently reads as -

=IF(ZEROS1="0","FAILED TO MEET","MEETS")

"David Biddulph" wrote:

Why not tell us the formula you're trying to use?
--
David Biddulph

"JaB" wrote in message
...
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

IF formula over multiple sheets
 

Why don't use AND / OR function to multiple check? For Example :
=IF(OR(SHEET1!A1=0,SHEET3!A1=0,SHEET5!A1=0),0,"Pas s")
or
=IF(AND(SHEET1!A1=0,SHEET3!A1=0,SHEET5!A1=0),0,"Pa ss")

"JaB" wrote:

Well, i thought the easiest approach would be to name the cells in the sheets
(as they do not run sequentially). So my formula currently reads as -

=IF(ZEROS1="0","FAILED TO MEET","MEETS")

"David Biddulph" wrote:

Why not tell us the formula you're trying to use?
--
David Biddulph

"JaB" wrote in message
...
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