🔥🔥 Excel Marksheet | Excel Marksheet kaise banaye | Formula of Sum, Percentage, Pass & Fail, Grade.
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- Advance Marksheet Formula Link: Pass/Fail/Compartment, Actual Pass/Fail
• All Marksheet Formula ...
Excel Marksheet | Excel Marksheet kaise banaye | Formula of Sum, Percentage, Pass & Fail, Grade.
Welcome to Global Star Edupoint provide video in excel from Beginner to advance.
Topic Cover Ms Excel Ms Excel Marksheet | Formula of Sum, Percentage, Minimum, Maximum, average, Rank, Grade, Pass & Fail and use of randbetween.
Thank you for watching Video:
Topic Cover
#Excel marksheet
#Excel Marksheet Kaise Banaye
#Formula sum
#formula percentage
#formula grade
Bahut achha samjhaya Sir apne thank you so much sir ji
Thank you sir itna acchi video banane k liye
Excellent 🎉 thanks sir👌
It is really helpful for me. Thank you so much 👍 God bless you 🙏
Thanks 🙏 for your support
Thank you so much 💞
Hello
Excellent.your way of teaching is superb.thank.keep it up 👍
Thanks and welcome
Thank you
You're welcome
Excellent ❤❤
Now it's to much easy for me. Thank you so much sir for this video 📷 please sir sortre in spreadsheet
Sir apne keval pass ke liye grade nikale hain,
Koi student ek subject me fail hai lekin anya subject me wo achhe number laya hai to uski percent 61 aa rahi hai to usme B grade dikh raha hai usme to E grade ya fail aana chahiye।
कृपया इसका फॉर्मूला बताएं
Hi my fast comment
Hi
Shorter ka video bhi banaa do please sir
अगर दो student के percent बराबर हो तो दोनों student के rank बराबर होगा या आगे पीछे । इस तरह के फार्मूले बताएँ
Same percentage mein same rank aayega
same percentage पर same number आ रहा है । परन्तु अगला नम्बर नहीं आ रहा है ।
जैसे 1, 2, 3, 3, 5, 6
ऐसा आ रहा है ।
4th rank नहीं आ रहा है । 3rd के बाद 5th आ रहा है ।
किसी दो बच्चों same number होने पर दोनों का same rank होने चाहिए । अगला का अगला होने चाहिए ।
एक बार आप चेक करके देखिये ।
आपके बताएँ अनुसार फार्मूले में
sir ji🙏
मान लो किसी क्लास में 5 students हैं ।
A
B
C
D
E
A को मिला है 96%
B को मिला है 94%
C को मिला है 97%
D को मिला है 96%
E को मिला है 92%
इसके अनुसार
Rank होने चाहिए
1 C को
2 A & D को
3 B को
4 E को
क्लास में इस तरह से rank निकाला जाता है ।
इस तरह के rank निकालने के लिए किस तरह के फार्मूले का उपयोग कर सकते हैं ।
Agar ranking ko ache se samajhna hh to dream 11 pe jab winners show kiye jate hh na wo dekho ranking samajh aa jayegi...
Agar B ke aage 3 bande hh use 3rd position kaise de denge is wajah se use 4th hi milega
Excellent
V good
Ye sb to thik hai but percentage 60% se above ho jaye but kisi ek subject me fail to is type se to pass n A grade hin batayega 😅
😮😮😮
Bhai wohi doubt clear karne ke liye 3 video dekh liya abhi tak kisi ne nhi bataya
@@nawedr586 bro if Formulah ka use kro ho jaaye
@@nawedr586 =IF(AND(
E31 >=30, F31 >=30,
G31 >=30, H31 >=30, 131 >=30),
"Pass","Fail")
Example ke liye ,sabhi subjects ka range do
@@Ajit_pubg😊😅😊😅😊😊
Agar same data filter me rahatho ??
Thanks 👍👍👍👍🙏🙏🙏🙏🙏
Sir plzz mujhe 12th ka marksheet bnana h sir plzzz tell me 😢😢😢
How to pass and fail and I have only true or false😢why
Absent unte
Sir pass/fail ka formula galt ho rha hai😢
Percentage ko divide ➗ kijiye total se aur jitna aae usme 100 se Guna kar dena hai
Apka answer aa jayega
=if(select percentage>=33%,"pass",if(select percentage>=25%",fail))
=If(Select percentage>=33%,"Pass","fail")press enter