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

  • @ghulammuhammad1971
    @ghulammuhammad197125 күн бұрын

    Zbrdst!!!

  • @GetSmarterEveryday1
    @GetSmarterEveryday12 жыл бұрын

    After watching 20 videos on pass and fail video, finally find subject wise pass and fail video thank you very much.

  • @MyLiveSupport

    @MyLiveSupport

    2 жыл бұрын

    Glad it helped!

  • @lakshmikantamandi4003
    @lakshmikantamandi40037 ай бұрын

    THANK YOU SIR. i HAVE BEEN BENEFITED WITH THIS VIDEO.

  • @BlackPanther-po9gh
    @BlackPanther-po9gh8 ай бұрын

    Op sir ji

  • @AnilPandey-sq8lt
    @AnilPandey-sq8lt2 жыл бұрын

    very use full

  • @adad5332
    @adad53323 жыл бұрын

    Thanks a lot for your video

  • @rakeshkumarrana7305
    @rakeshkumarrana73054 жыл бұрын

    👌👌👌👌

  • @ruchim65
    @ruchim653 жыл бұрын

    Perfect video 👍🏻👌

  • @bhaweshsingh5991
    @bhaweshsingh59915 жыл бұрын

    I am very confused about this function ,but now I got it , thank you sir

  • @NRW_240
    @NRW_2404 жыл бұрын

    Thanks a lot for video! 🙏

  • @ac34akashrao90
    @ac34akashrao902 жыл бұрын

    Thank you so much sir.

  • @deepaksingh-ph7cv
    @deepaksingh-ph7cv5 жыл бұрын

    Thanks bro for helping me

  • @frag_out1500
    @frag_out15004 жыл бұрын

    Great Video! the perfect one! :D

  • @atworld544
    @atworld5442 жыл бұрын

    thanku

  • @swarnalatajena937
    @swarnalatajena9373 жыл бұрын

    Thank you Sir

  • @HARIOMYADAV-wh1hk
    @HARIOMYADAV-wh1hk Жыл бұрын

    Thank You 🙏🙏

  • @pankajchudasama5596
    @pankajchudasama55963 жыл бұрын

    Best video of results in entire KZread

  • @sachinbagan6355
    @sachinbagan63554 жыл бұрын

    Thanks sir

  • @anupammultimedia3235
    @anupammultimedia32355 жыл бұрын

    Thank you bro

  • @blackmangamer9265
    @blackmangamer92652 жыл бұрын

    Thank you ❤️

  • @Touristknowledge360
    @Touristknowledge3603 жыл бұрын

    Tq

  • @RashidAli-xc1ei
    @RashidAli-xc1ei3 жыл бұрын

    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

  • @aartichauhan8960
    @aartichauhan89606 жыл бұрын

    Nice sir, thanks

  • @MyLiveSupport

    @MyLiveSupport

    6 жыл бұрын

    Most welcome Aarti ji😀

  • @greatindiamusicworld8039
    @greatindiamusicworld80395 жыл бұрын

    thanks bro ji

  • @MyLiveSupport

    @MyLiveSupport

    5 жыл бұрын

    welcome bro

  • @TheShubhamPodcast
    @TheShubhamPodcast5 жыл бұрын

    Nyc

  • @lipunsahu1051
    @lipunsahu10512 жыл бұрын

    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.

  • @userfhhfjhggjk
    @userfhhfjhggjk6 жыл бұрын

    Sir ek student mark shEet par full vedio banaye please

  • @rizaulali7380
    @rizaulali73806 жыл бұрын

    I love you And Thanks....

  • @MyLiveSupport

    @MyLiveSupport

    6 жыл бұрын

    Love you too

  • @nitishpradhan7375
    @nitishpradhan73753 жыл бұрын

    That's i was finding

  • @AMITJAIN-vo7tm
    @AMITJAIN-vo7tm2 жыл бұрын

    How to use if function when any student is absent in all exam or particular subject.

  • @uzzalkumarbhattacharjee2055
    @uzzalkumarbhattacharjee20555 жыл бұрын

    How can I separate all pass in one page and all fail in other page.

  • @TusharKantiDutta1200
    @TusharKantiDutta1200Ай бұрын

    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 🙏

  • @mohammedkalimulla5936
    @mohammedkalimulla59362 ай бұрын

    how to calculate a student absent in one subject using IF AND Logical function ? pls

  • @rajeevgosavi4514
    @rajeevgosavi45143 жыл бұрын

    Can you please upload a video comprising if, and, or formula in one example.

  • @hafeesification
    @hafeesification4 жыл бұрын

    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

  • @crazybaby1
    @crazybaby14 жыл бұрын

    Sir agar hame subject wise division banana ho to kaise banayenge

  • @MyLiveSupport

    @MyLiveSupport

    4 жыл бұрын

    You can try same method

  • @zubairali7981
    @zubairali7981 Жыл бұрын

    If I want to show pass book names in result which formula I am use

  • @deepjyotitalukdar3470
    @deepjyotitalukdar3470 Жыл бұрын

    How to colour the cells in case student fail in one subject or more than 1.

  • @muhammadtahirkhan3366
    @muhammadtahirkhan33663 жыл бұрын

    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

  • @amitkr9214
    @amitkr92145 жыл бұрын

    Sir yadi ham chahte hain ki 2 ya 2 se upar ke paper me fail ho to fail hoga otherwise pass

  • @jannaskhan2489
    @jannaskhan2489 Жыл бұрын

    I want to mark a student Fail.if he fails in three subjects,what formula will be used

  • @ankitkushwaha1525
    @ankitkushwaha15255 жыл бұрын

    सर अगर इस शीट में फ़ैल या पास के अलावा कम्पार्टमेंट को भी दिखाना चहाये तो उसको कैसे दिखाये गए

  • @pinkirajput9725
    @pinkirajput97254 жыл бұрын

    Agar koyi kisi sub. Mein fail h to kya uske fail marks total marks mein add honge?

  • @brijmohanmeena7288
    @brijmohanmeena7288Ай бұрын

    Sii By Grace and supplementary kaise show kare

  • @danzzy0000
    @danzzy00005 жыл бұрын

    What about instead of pass we show grades A,B,C,D and for F show fail??

  • @yogeshglimbarkar5307
    @yogeshglimbarkar53074 жыл бұрын

    If any student is absent for any one subject then how to modify the formula

  • @kedukolokupa4770
    @kedukolokupa47703 жыл бұрын

    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...

  • @nitinkumarkamble8477
    @nitinkumarkamble84774 жыл бұрын

    Studentकितने विषयोंमे फेल है ये कैसे count करे as like f1 f2 f3

  • @abbasmomin9636
    @abbasmomin96364 жыл бұрын

    How to calculate students fail in total subjects. Kindly share link or formula

  • @sumitmishra6021
    @sumitmishra60215 жыл бұрын

    Sir if I have to use pass and fail and atkt ??

  • @MyLiveSupport

    @MyLiveSupport

    5 жыл бұрын

    You can use multiple condition

  • @mohammadrafi1572
    @mohammadrafi15724 жыл бұрын

    Sir fail sub highlighting how to do in if funcation

  • @jagdishkhatkar9076
    @jagdishkhatkar90764 жыл бұрын

    मै चाहता हूँ टोटल उसी student का हो जो पास हो क्या ये possible हे प्लीज tell me

  • @sonukumarkurre1010
    @sonukumarkurre10104 жыл бұрын

    Supply wala kaise nikale

  • @ManojPatel-wn1zk
    @ManojPatel-wn1zk4 жыл бұрын

    pass कितने हुए और fail कितने हुए हे ये संख्या में कैसे निकालेंगे

  • @kunalmali848
    @kunalmali8485 жыл бұрын

    Eexl shikha haa

  • @DEEPAKKUMAR-rw3ji
    @DEEPAKKUMAR-rw3ji4 жыл бұрын

    How the select cell l4

  • @rajanchinu1438
    @rajanchinu14382 жыл бұрын

    where is supply

  • @Jojok989
    @Jojok989 Жыл бұрын

    Bhaiaya nahi ho rha

  • @ZohebHassanlashari
    @ZohebHassanlashari2 жыл бұрын

    Thanks sir

  • @paul3753
    @paul3753 Жыл бұрын

    Thank you sir

Келесі