How to Calculate Pass or Fail Subject Wise Using IF AND Logical Function
How to Calculate Pass or Fail Subject Wise Using IF AND Logical Function | ये फाॅर्मूला नहीं सीखोगे तो पछताओगे - Doston is video me maine bataya hai ki kis tarah hum If Formule ke andar AND Logical Function ka use karke IF Formule ko powerful bana sakte hai.Hope apko video pasand aayega.
❤Show your LOVE by “ LIKE COMMENT & SHARE this video ”
❤Don’t forget to “SUBSCRIBE & PRESS THE BELL ICON”
Please support me on
Like us on Facebook - / mylivesupport
Website - mylivesupport.in/
Follow us on Twitter - / mylivesupport
Follow us Instagram - / mylivesupport
Facebook Myself - / chandankumar926
KZread - / mylivesupport
▶️WATCH ALL VIDEOS FROM BELOW PLAYLIST :
▶️All Video for MS Excel Magic Trick Series - goo.gl/qS296Q
▶️All Advanced Excel Video in Hindi - bit.ly/2Ej6Viy
▶️All Computer Tips and Tricks Video in Hindi - bit.ly/2Pj70Ji
▶️Top 10 Excel Video in Hindi - goo.gl/McEe53
▶️All Videos of Excel in Hindi - goo.gl/boUo8C
▶️All Videos of Technology in Hindi - goo.gl/E9VyCA
▶️All Videos of MS Excel VBA in Hindi - goo.gl/W4pb5t
▶️All Videos for Tally.ERP9 GST in Hindi - goo.gl/CbsFhr
Most Useful Videos of Our Channel - Must Watch
▶️How to Convert Handwritten Notes in MS Word using Google Drive | Hindi Tutorial • How to Convert Handwri...
▶️How to Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi • How to Maintain Attend...
▶️Make Fully Automatic GST Invoice | Bill in Excel | Auto Save Each Invoice | Multi Items & GST Rate • Make Fully Automatic G...
▶️🔥How to Recover Unsaved MS Office Files | Excel | Word | PowerPoint without any Software 🔥 • 🔥How to Recover Unsave...
▶️Excel में किसी भी Sheet को Print करो Expert की तरह | Become MS Excel Expert • Excel में किसी भी Shee...
▶️Ms Word में Expert बनना है तो इन 5 Magical Tricks का USE करना सीखलो • Ms Word में Expert बनन...
▶️Excel की इन 20 Shortcut Key का Use करना सीख लो | Become Excel Expert | My Live Support • Excel की इन 20 Shortcu...
▶️ऑफिस में बनना है सबसे Smart तो MS Word की इन 20 Magical Tricks का Use करना सीखलो • ऑफिस में बनना है सबसे ...
▶️4 Super Cool Tricks for MS Excel | Excel Magic Trick Part 13 • 4 Super Cool Tricks fo...
▶️बॉस को करना है Impress तो Excel में ये 4 Super Tricks जरुर सीखें | Excel Magic Tricks Part 6 • बॉस को करना है Impress...
▶️How to Convert any Image to Excel | MS Excel New Feature Tutorial in Hindi • How to Convert any Ima...
Our aim behind making this channel to make you expert in Microsoft Excel, Microsoft Word, Tally.ERP9, Computer and Technology. You can easily learn Excel, Word, Tally, Internet, Computer in Hindi language. So don’t forget to Subscribe Our Channel.
---------------- Chandan Kumar ----------------
Пікірлер: 66
Zbrdst!!!
After watching 20 videos on pass and fail video, finally find subject wise pass and fail video thank you very much.
@MyLiveSupport
2 жыл бұрын
Glad it helped!
THANK YOU SIR. i HAVE BEEN BENEFITED WITH THIS VIDEO.
Op sir ji
very use full
Thanks a lot for your video
👌👌👌👌
Perfect video 👍🏻👌
I am very confused about this function ,but now I got it , thank you sir
Thanks a lot for video! 🙏
Thank you so much sir.
Thanks bro for helping me
Great Video! the perfect one! :D
thanku
Thank you Sir
Thank You 🙏🙏
Best video of results in entire KZread
Thanks sir
Thank you bro
Thank you ❤️
Tq
Agar passing criteria har subject ka change ho to us men pass fail ka kese formula use hoga and agar hamen passed papers count krne ho aur har subject k passing marks different ho to woh kese hoga
Nice sir, thanks
@MyLiveSupport
6 жыл бұрын
Most welcome Aarti ji😀
thanks bro ji
@MyLiveSupport
5 жыл бұрын
welcome bro
Nyc
Hi sir🙏🏻... Applying the "or" function without applying the "and" logical function in this formula will do the better... Because the value comes by following the total subject mark in the "and" function, the value comes by checking the subject by subject in the "or" function. This comment formula has to check the pass failed as per the subject... Therefore, the "or" function should be applied.
Sir ek student mark shEet par full vedio banaye please
I love you And Thanks....
@MyLiveSupport
6 жыл бұрын
Love you too
That's i was finding
How to use if function when any student is absent in all exam or particular subject.
How can I separate all pass in one page and all fail in other page.
Bhai ek sawal hai ki, ye trick to thik tha par mera problem ye hai ki har ek subject mei number ke basis me pass 1, pass 2, pass 3, ...... show karwana hai iske liye konsa function kaam karega plz reply 🙏
how to calculate a student absent in one subject using IF AND Logical function ? pls
Can you please upload a video comprising if, and, or formula in one example.
sir after pass or fail basis i want to find average function or percentage function(average only if student were passed, and give them a grade ie >90 a+ >80 a like that please help me sir
Sir agar hame subject wise division banana ho to kaise banayenge
@MyLiveSupport
4 жыл бұрын
You can try same method
If I want to show pass book names in result which formula I am use
How to colour the cells in case student fail in one subject or more than 1.
Sir is ki samag a gai magar agar isi farmula me ye bi add karna ho ke jis ki percentage 35 sy kam ho wo bi fail ho jaye to ye kaisy karen
Sir yadi ham chahte hain ki 2 ya 2 se upar ke paper me fail ho to fail hoga otherwise pass
I want to mark a student Fail.if he fails in three subjects,what formula will be used
सर अगर इस शीट में फ़ैल या पास के अलावा कम्पार्टमेंट को भी दिखाना चहाये तो उसको कैसे दिखाये गए
Agar koyi kisi sub. Mein fail h to kya uske fail marks total marks mein add honge?
Sii By Grace and supplementary kaise show kare
What about instead of pass we show grades A,B,C,D and for F show fail??
If any student is absent for any one subject then how to modify the formula
Very helpful..... Can you please show me how to make dash line (--) for the failed students in the total column instead of showing marks using excel formula. Only show the pass students marks and failed students in dash line (--). Thanks...
Studentकितने विषयोंमे फेल है ये कैसे count करे as like f1 f2 f3
How to calculate students fail in total subjects. Kindly share link or formula
Sir if I have to use pass and fail and atkt ??
@MyLiveSupport
5 жыл бұрын
You can use multiple condition
Sir fail sub highlighting how to do in if funcation
मै चाहता हूँ टोटल उसी student का हो जो पास हो क्या ये possible हे प्लीज tell me
Supply wala kaise nikale
pass कितने हुए और fail कितने हुए हे ये संख्या में कैसे निकालेंगे
Eexl shikha haa
How the select cell l4
where is supply
Bhaiaya nahi ho rha
Thanks sir
Thank you sir