Pass,Fail or blank for 2 or more column

[J.carolino86]

excel.PNG

Anyone who can help me regarding with this kind of error that i encountered

Thank you very much or helping

[PaulM100]

Try this:

=IF(AND(ISBLANK(b4),ISBLANK(c4),ISBLANK(d4),ISBLANK(e4)),"",your formula))
or use OR instead of AND.

[davsth]

if all 4 need to be completed
=IF(COUNTIF(B4:E4,">=0")<4,"",IF(COUNTIF(B4:E4,">=40")<4,"Fail","pass"))

[J.carolino86]

Try this:

=IF(AND(ISBLANK(b4),ISBLANK(c4),ISBLANK(d4),ISBLANK(e4)),"",your formula))
or use OR instead of AND.

excell2.PNG


sir
Would you please help me to learn using the excell formulas,
because I'm only starting to learn regarding the excell. I do not know how to apply
Do you want to answer it for me,if its okay to you

[AliGW]

Try this:

=IF(AND(ISBLANK(B4),ISBLANK(C4),ISBLANK(D4),ISBLANK(E4)),"",IF(AND(B3>=30,C3>=30,D3>=30,E3>=30),"Pass","Fail"))

[J.carolino86]

pf.PNG

Thank you very much maa'm its works

[J.carolino86]

there's one more question maam
What about the data for with minimum and maximum data limit for pass & fail
without selecting the minimum and maximum
me i know the formula for this

with minimum&maximum.PNG

[AliGW]

Just introduce five more criteria:

=IF(AND(ISBLANK(B4),ISBLANK(C4),ISBLANK(D4),ISBLANK(E4)),"",IF(AND(B3>=F4,C3>=F4,D3>=F4,E3>=F4,B3<=G4,C3<=G4,D3<=G4,E3<=G4),"Pass","Fail"))

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[J.carolino86]

Just introduce five more criteria:

=IF(AND(ISBLANK(B4),ISBLANK(C4),ISBLANK(D4),ISBLANK(E4)),"",IF(AND(B3>=F4,C3>=F4,D3>=F4,E3>=F4,B3<=G4,C3<=G4,D3<=G4,E3<=G4),"Pass","Fail"))

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

how to make my thread solved maam

[bebo021999]

Another option:

Please Login or Register  to view this content.