Function Help
 

"If value in either cell I3 and J3 =0 "Pass", If If value in either cell I3
or J3 <0, "Fail"

=IF(I30,IF(I3<0,"Pass","Fail"))IF(J30,IF(J3<0, "Pass","Fail")) If this is
wrong; please correct it

Thanks;

one way:

=IF(AND(I3=0,J3=0),"Pass","Fail")



In article ,
Jay wrote:

"If value in either cell I3 and J3 =0 "Pass", If If value in either cell I3
or J3 <0, "Fail"

=IF(I30,IF(I3<0,"Pass","Fail"))IF(J30,IF(J3<0, "Pass","Fail")) If this is
wrong; please correct it

Thanks;

I cant tell from what you say whether both have to equal 0 for for there to
be pass or if both have to not equal zero for the result to be "fail"
I would use
<both equal zero to pass
=if(and(I3=0,J3=0),"pass","fail")
or
<at least one equal zero to pass
=if(or((I3=0,J3=0),"pass","fail")
depending one whether one or both have to equal zero to pass

"Jay" wrote:

"If value in either cell I3 and J3 =0 "Pass", If If value in either cell I3
or J3 <0, "Fail"

=IF(I30,IF(I3<0,"Pass","Fail"))IF(J30,IF(J3<0, "Pass","Fail")) If this is
wrong; please correct it

Thanks;

=IF(AND(I3=0,J3=0),"pass","fail")

If both I3 and J3 are empty, the formula will still return "Pass".

If either I3 or J3 hold the numeric entry of 0 and the other cell is empty,
the formula will still return "Pass".

Biff

"Jay" wrote in message
...
"If value in either cell I3 and J3 =0 "Pass", If If value in either cell
I3
or J3 <0, "Fail"

=IF(I30,IF(I3<0,"Pass","Fail"))IF(J30,IF(J3<0, "Pass","Fail")) If this
is
wrong; please correct it

Thanks;