exel formula ekak gahanna help ekak oni

[arovis20]

There are 6 Subjects, (A,B,C,D,E,F are columns)
A- Maths
B- Bio Science
C- Physics
D -Chemistry
E -English
F -Computer Science

all student's subject wise Passing score is 50, Maths and Bio and physics Pass is compulsory and also from remain 3 subject any one subject should pass to get final level. how to create excel formula for that?

 

[හෙළයෙක්]

FYI - @kasun090354t

 

[tharakaf]

There are 6 Subjects, (A,B,C,D,E,F are columns)
A- Maths
B- Bio Science
C- Physics
D -Chemistry
E -English
F -Computer Science

all student's subject wise Passing score is 50, Maths and Bio and physics Pass is compulsory and also from remain 3 subject any one subject should pass to get final level. how to create excel formula for that?

@AnuradhaRa ponnaya puluwanam muta help ekak deepan.

 

[dmsupun]

ලාමක විදියක් කියන්නම්,
සබ්ජෙක්ට් එක පාස් නම් කොලම් එකකට 1 වැටෙන්න if එකක් දාල, කම්පල්සරි ඒවගෙ එකතුව 3 ආවමයි අනිත් ඒවගෙ එකතුව >= 1 ආවමයි පාස් වෙන විදියට හදපන්.

 

[hacker T]

subscribe for education purpose

 

[DHE]

BUMP

OL kalen passe Excel use kare na

 

[Honda.putha]

=IF(AND(A3>=50,B3>=50,C3>=50),IF(OR(D3>=50,E3>=50,F3>=50),"passed","failed"),"failed")

 

[mamanamperi]

=IF(AND(A1>=50,B1>=50,C1>=50,OR(D1>=50,E1>=50,F1>=50)),"PASS","FAIL")

 

[U-tag]

If එකයි v lookup එකයි දාලා එකක් හැදුවා. හැබැයි steps කීපයක් තියනවා.

 

[arovis20]

=IF(AND(A3>=50,B3>=50,C3>=50),IF(OR(D3>=50,E3>=50,F3>=50),"passed","failed"),"failed")

Thank you so much machan,


mekedi total subjects 10K TIBILA compluslary 3k pass wennaii ithiri 7n 3k passwela tibboth final eka pass kiyala hadaganne kohoamd machan ekath chuttak kiyanna

 

[Honda.putha]

Thank you so much machan,


mekedi total subjects 10K TIBILA compluslary 3k pass wennaii ithiri 7n 3k passwela tibboth final eka pass kiyala hadaganne kohoamd machan ekath chuttak kiyanna

=IF(AND(A3>=50,B3>=50,C3>=50),if(countif(D3:J3,">=50") >= 3,"passed","failed"),"failed")

 

[1118lakmalkumara]

=IF(AND(A3>=50,B3>=50,C3>=50),if(countif(D3:J3,">=50") >= 3,"passed","failed"),"failed")

machan VL walain vitharak oka karanna barida "true" karala

 

[spunkyisii]

@AnuradhaRa ponnaya puluwanam muta help ekak deepan.

Wena ekekta udaw karanna ? Mooo ponnayata echra deyak karaganna puluwan nam itin

 

[tharakaf]

Wena ekekta udaw karanna ? Mooo ponnayata echra deyak karaganna puluwan nam itin

Ponz awe naneda? Ammo ban uge wadak unanam itin

 

[kasun090354t]

machan VL walain vitharak oka karanna barida "true" karala

VL වලින් මෙහෙම එකපාර උත්තරයක් ගන්න බෑ නේද.

 

[TonyMontana83]

@AnuradhaRa ඇත්තට මූට හෙල්ප් එකක් දියංකෝ.

 

[AnuradhaRa]

@AnuradhaRa ඇත්තට මූට හෙල්ප් එකක් දියංකෝ.

=AND(A3>50,B3>50,C3>50,COUNTIF(D3:F3,">50")>=1)

A3 Maths
B3 Bio
C3 Physics
D3:F3 Chemistry, English, Computer sci

=IF(AND(A3>=50,B3>=50,C3>=50,OR(D3>=50,E3>=50,F3>=50)),"Pass","Fail")

 

[tinto brass]

https://www.google.lk/search?q=exce...XCIAZ4OkgEEMTguMpgBAKABAbABCg&sclient=gws-wiz

menna mekunith one nam okata wadak ganna puluwan wei..

 

[TonyMontana83]

=AND(A3>50,B3>50,C3>50,COUNTIF(D3:F3,">50")>=1)

A3 Maths
B3 Bio
C3 Physics
D3:F3 Chemistry, English, Computer sci

Ela

 

[AnuradhaRa]

Ela

50 ත් පාස් නිසා = කිරීමකුත් දැම්ම

=AND(A3>=50,B3>=50,C3>=50,COUNTIF(D3:F3,">50")>=1)

මෙහෙමත් පුළුවන්

=AND(A3>=50,B3>=50,C3>=50,OR(D3>=50,E3>=50,F3>=50))

=IF(AND(A3>=50,B3>=50,C3>=50,OR(D3>=50,E3>=50,F3>=50)),"Pass","Fail")