Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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; |
#2
|
|||
|
|||
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; |
#3
|
|||
|
|||
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; |
#4
|
|||
|
|||
=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; |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |