Thread: Function Help
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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;