Pass-Fail Formula in Excel (Hindi) Student Marksheet by =If Formula and Percentage Formula in Excel

Поделиться
HTML-код
  • Опубликовано: 16 сен 2024
  • Download Practice Sheet Here:
    👉 www.techgurupl...
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    👉 Buy Excel Course: - TechGuruPlus.c...
    👉 My Instagram: - / techguruplus
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    (1) Excel की सारी वीडियो यहां पर देखें
    🔹 • Top 20: Advanced Excel...
    (2) Tally की सारी वीडियो यहां पर देखें
    🔹 • Email through Tally wi...
    (3) Pivot Table की सारी वीडियो यहां पर देखें
    🔹 • Pivot Table Part-1 in ...
    (4) Macro की सारी वीडियो यहां पर देखें
    🔹 • MACRO (PART-2) Salary ...
    (5) Tally TDL की सारी वीडियो यहां पर देखें
    🔹 • Download All TDL File ...
    (6) Online Tricks की सारी वीडियो यहां पर देखें
    🔹 • Restore Chrome Tabs Af...
    (7) Sponsored की सारी वीडियो यहां पर देखें
    🔹 • Edraw Max: Perfect Sof...
    (8) Gadgets Review की सारी वीडियो यहां पर देखें
    🔹 • MI Power Bank 10000mAH...
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    My Social Media Links:
    (1) Excel Expert's Facebook Group
    🔴 / excelexpertgroup
    (2) LinkedIn
    🔴 / nazimkhaan
    (3) Facebook Page
    🔴 / techguruplus
    (4) Twitter
    🔴 / techguruplus
    (5) RUclips
    🔴 / techguruplusindia
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    Contact for Business Inquiry :
    ✉ info@TechGuruPlus.com
    ✉ nazim.khan09@gmail.com
    Channel Owner: Nazim Khan
    🏆 Experience: 10 Years+
    ⏳ Website : ► www.TechGuruPlu...
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    #TechGuruPlus #NazimKhan

Комментарии • 93

  • @business-excel
    @business-excel  4 года назад +2

    Download Practice Sheet Here:
    👉 www.techguruplus.com/pass-fail-formula-in-excel/
    👉 Join my Excel Course: - TechGuruPlus.com/Excel-Course/
    👉 Contact :- 9536250020
    👉 My Instagram: - instagram.com/TechGuruPlus

    • @Brojodd
      @Brojodd 2 года назад

      Sir thanku sir I am a grade 7 student and I was struggling to know the formula of pass or fail and your helped so much thanku sir

  • @bhogiram8188
    @bhogiram8188 Год назад

    Sir sare formulas bataya aap bahut achha samjhte h

  • @arshipathan7726
    @arshipathan7726 3 года назад

    Thank you sir apke samjhne ka tareeka v bhot accha h or mujhe samjh v aaya

  • @sureshnagwan7805
    @sureshnagwan7805 3 года назад

    Bahut badhiya jankari di h apne

  • @bobbygill5702
    @bobbygill5702 Год назад

    Good job sir

  • @Tracks777
    @Tracks777 4 года назад +2

    amazing content

  • @netridevi8147
    @netridevi8147 2 года назад +1

    Thank you so much

  • @Tracks777
    @Tracks777 4 года назад

    lovely video

  • @netridevi8147
    @netridevi8147 2 года назад

    Its really helpful for me

  • @maahichaturvedi72
    @maahichaturvedi72 2 года назад

    Osm👌🏻👌🏻👌🏻👌🏻👌🏻

  • @VIVEKKUMAR-tj5ir
    @VIVEKKUMAR-tj5ir 3 года назад

    It's new for me, thanks

  • @jagannathkumar5551
    @jagannathkumar5551 Год назад

    Mast sir

  • @Tracks777
    @Tracks777 4 года назад

    nice content

  • @Jitenderkumar-yp1rn
    @Jitenderkumar-yp1rn 4 года назад +1

    Good...😍

  • @le_78_mahvish_cseqummer23
    @le_78_mahvish_cseqummer23 3 года назад

    Thnks.it helped

  • @rajtandan5601
    @rajtandan5601 2 года назад

    thank you sir ji😍😍

  • @abeehashabir1357
    @abeehashabir1357 3 года назад

    Nice

  • @prabhukhadiya0075
    @prabhukhadiya0075 3 года назад

    Nice class sir

  • @izzathurair8323
    @izzathurair8323 3 года назад

    Very helpful vdeo...👍🏻Allah bless you

  • @iqrabibi9464
    @iqrabibi9464 3 года назад

    Zbrdast sir g

  • @lovesongs4746
    @lovesongs4746 4 года назад

    Thanks sir

  • @dscreation837
    @dscreation837 2 года назад

    Student attends sheet in Excel pe video bano

  • @artimeena5561
    @artimeena5561 3 года назад

    tnx sir🙏

  • @taruntuvar4644
    @taruntuvar4644 2 года назад +6

    Koi Subject me Fail huva to kahase Pass huva ?? Apne to Percentage par Result nikala hai

  • @deepakkumarsingh1381
    @deepakkumarsingh1381 3 года назад +1

    sir agar mujha marks palace mai pass rakha hai aur thoda student fail hai exam mai then and I want only the name of all pass student In very subject then which formulae I can use?

  • @moveon6907
    @moveon6907 4 года назад

    Nyc

  • @sunitapatel9709
    @sunitapatel9709 3 года назад +2

    If one secure 12 mark in one sub and others > 33 then how to put formula for it

  • @AMITJAIN-vo7tm
    @AMITJAIN-vo7tm 2 года назад

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

  • @mehndi755
    @mehndi755 2 года назад

    Sir inter me kesy pata chalegaa inter me bi esa hi ho ga a

  • @pavanmavi150
    @pavanmavi150 3 года назад

    😊😊

  • @paramountcomputersdeoband7737
    @paramountcomputersdeoband7737 2 года назад +1

    Sir eak subject main bachchaa fail hay to usay ham kaysay fail Sabit karaingay. Jab ki Saray subject Kay no. Total karnay per 75%no. Hain.

  • @Barbie_in_pakistan
    @Barbie_in_pakistan 2 года назад

    min marks 2 subjects k liye different or 6 k loiye different..inko kesy pass or faill krengy?

  • @shirazjutt3016
    @shirazjutt3016 2 года назад

    Sir plzzzz ya Jo sheet kolam blank kiye ha ya bta dain kasa hota ha kindlyyyy apki mahrbai ho giiii Mujha bohat zarorat ha iskiiiii

  • @BalkrishnaAdhikaribk
    @BalkrishnaAdhikaribk 3 года назад

    Jo koi subject mai fail he lekin percentage jyada hei usko pass dikhana sahi nahi he esa condition mae konsa tecnic chaie? Please expaln.

  • @missiram6521
    @missiram6521 2 года назад

    Result me kuch subject me faill huwe ho to uska formula?

  • @partap185
    @partap185 4 года назад

    Mdm reg ko mentain krne ka farmula bnaiye sir

  • @syedmahaboobhasan8661
    @syedmahaboobhasan8661 4 года назад

    Assalamualaikum sir, subject wise pass or fail result banana hoto formula kaise dale
    Subject and internal marks hoto than how to give pass / fail formula iss ka bhi video banaye please

  • @pirooo6544
    @pirooo6544 Год назад +1

    Agar percentage 33 se jyada hai paar ek subject me fail hua toh?

  • @sadhanaverma1618
    @sadhanaverma1618 9 месяцев назад

    Isske age ka btaye sir

  • @rahuljain7684
    @rahuljain7684 3 года назад

    Yadi passing mark cast wise ho to result kaise banaye

  • @kamalpatel9013
    @kamalpatel9013 2 года назад

    Kindly tell how to calculate no of students passed in only 1 subject or passed in only 2 subject

  • @azadari1109
    @azadari1109 4 года назад

    hello sir, agar kisi ko "pass" Yan "fail" obtained marks or percentage ki base par nikalny ka formula

  • @hemtiwari5520
    @hemtiwari5520 Год назад

    Siri kewal percentage ke base par result nahi banta. Grace marks, medical , absent etc. Multiple condition laga kar real mark sheet banti hai

  • @befunny1717
    @befunny1717 2 года назад

    Sir agar koi ek subject me fail ho aur pure me pass to fail kaise dikahye ge

  • @bhavishyasaini1992
    @bhavishyasaini1992 2 года назад

    Good morning sir.
    ye to total Mark's ki percentage k according pas/fail sahi h
    Kintu subject me total 33se km h TB fail kaise show krenge

  • @mohdazam5501
    @mohdazam5501 2 года назад

    Hello sar

  • @aminpinjari4070
    @aminpinjari4070 2 года назад

    मुझे बॉय 60 टक्के के मे कितन ओर गर्ल्स 60 टक्के के मे कितने काऊंट फ्रमुला कैसे लगाए

  • @manishsrivash8670
    @manishsrivash8670 4 года назад

    Sir plz supplymentry ka to bnao vidio 2 subject ka koe bhi nhi bnaya h supply sbhi pass or so fail ka bna rhe ho plz give me link jaldi bnao

  • @shreeomvishwakarma9024
    @shreeomvishwakarma9024 2 года назад

    Sir 10th marksheet kase bnaye

  • @mathsmanju4868
    @mathsmanju4868 2 года назад

    In exam if one subject fails then result also showing fail. How to make this

  • @abherambhaijoshi9759
    @abherambhaijoshi9759 4 года назад

    भाई मेरी टाईल्स की दुकान है तो इस पर विडिओ बनाओ प्लीज

  • @mohdazam5501
    @mohdazam5501 2 года назад

    Hello

  • @balchandrasisodiya5739
    @balchandrasisodiya5739 2 года назад

    Subject wise 33% se kam marks prapt hone par fail ya supplementary wala formula ho to bataayen.

  • @dianaayan8203
    @dianaayan8203 Год назад

    Hi
    What if it's 20 marks paper? (Unit Test)

  • @amitrajput-fs9bz
    @amitrajput-fs9bz Год назад

    aur yadi ye 3 subject me fail ho to uske liye to formula btayo

  • @rabiarabi2800
    @rabiarabi2800 Год назад +1

    less then 30% wala pass hota hai ya fail ???

  • @neelamdh2926
    @neelamdh2926 Год назад

    But sir,, bachha kisi subject me absent ho jaye or baki k subject me 90% marks la rha ho tab to wo 33 se bhi upar chala jaega matlab wo bhi pass ki category me aaega but un reality to wo fail kahlaegaa.. Tab kaise formula apply katenge

  • @romiyarkafle214
    @romiyarkafle214 2 года назад

    De d± pls aaho pass ki fail 1.65 aayo pass ki fail bro

  • @harshrajput8018
    @harshrajput8018 2 года назад

    Sir aapne pass fail mai m5 kyo liya tha

  • @abhirchhetri7990
    @abhirchhetri7990 Год назад

    All over main pass hai but Subject main to fail hai

  • @jitendradore9529
    @jitendradore9529 3 месяца назад

    Total marks se pass ya fail kaise ho sakta hai. Kuch student 1 ya 2 me fail bhi to ho sakte hai
    Tab kya karege. Its wrong

  • @shribponline1602
    @shribponline1602 3 года назад

    सर छात्रों का जब रिजल्ट बनाते हैं तो कई छात्रों को grace के अंक देकर पास किया जाता है यदि छात्रों को ग्रेस के अंक देना हो तो कैसे दें ग्रेस के कुल अंक 10 हैं तथा तीन विषयों में देना है तो कैसे दें

  • @mohdazam5501
    @mohdazam5501 2 года назад

    Aap number kam Bharti kar sakte ho kya sar

  • @MR.PANKAJSAHU
    @MR.PANKAJSAHU 3 года назад

    myself Pankaj Sahu Sar Mujhe supplementary wali marksheet banana or sar sabject ka name bhi aana chahiye sar🙏 place

  • @yogendrayadav1977
    @yogendrayadav1977 2 года назад

    Yadi 33% paass hai hum 33% neutral 34% aaya to pass and 32% aaya toh fail kaise set kare

  • @sandhyapatelpatel4952
    @sandhyapatelpatel4952 2 года назад

    Sir Coding par

  • @shayanarif445
    @shayanarif445 2 года назад

    Sir mera result aya h mgr mara or mara dost k same num h but ma fail h or wo pass is k koi sul plz repp

  • @ageverything21
    @ageverything21 2 года назад

    Poori jankari nhi h video me

  • @supravanayak6305
    @supravanayak6305 3 года назад

    Sir second person jo he bo english me 12 mark rakha he to boto fail huana

  • @krishavsinghbabydance2002
    @krishavsinghbabydance2002 3 года назад

    Excel mai average nikaltey time 0 aaye to 0 ko nai lena hai .formula batao

  • @romiyarkafle214
    @romiyarkafle214 2 года назад

    Link

  • @imranbaig7045
    @imranbaig7045 3 года назад

    Jiska subject me kam h to wo kaise pass hoga

  • @pradeepchavan7225
    @pradeepchavan7225 Год назад

    Aapki mark sheet me English aur Hindi me 20 se bhi Kam marks hai to basically fail, dikana chahiye AAP ka formula wrong ho gaya hai.
    Krupaya sahi Gyan de. Dhanyawad

  • @muhammadsohail7036
    @muhammadsohail7036 4 года назад

    NAZIM SIR, ASSALAMO ALAYKUM MAIN MOHAMMAD SOHAIL LAHORE PAKISTAN SE HUN
    SIR MUJHE 1 BOHAT BARI PROBLEM AA RAHI HAI WO YE KE MAIN JAB EXCEL MAIN KAAM KER RAHA HOTA HUN TO KAM KERNE KE BAAD JAB FILE KO SAVE KERNE KI KOSHISH KERTA HUN ERROR AA JATA HAI KE MS EXCEL HAS STOP WORKING YA PHIR DOOSRA YE KE 1 OR ERROR AA JATA HAI LIKHA HOTA HAI KE AUTO SAVE DISABLE HAI OR USKE BAAD SHEET BLANK HO JATI HAI OR KOI WORK NAHI HOTA US PE MAIN MS EXCEL-2016 OR WINDOWS 8 USE KER RAHA HUN MERE PAS DELL KA LAPTOP HAI VOSTRO 1510 ISKI RAM 4 GB HAI PLEASE SIR MUJHE GUIDE KIJIYA OR SHUKRIYA KA BOHAT BOHAT MOQA DIJIYE ------ALLAH AP KO HAMESHA ISI TARAH CHAMKTA DAMAKTA RAKHE AAMEN

  • @syedhabeebuddin274
    @syedhabeebuddin274 4 года назад +1

    Completely wrong method, don't follow him, pass or fail cannot be calculating on average marks, what about if any one student secure 5 Subject above 90 marks and in 1 subject 30 marks.... So you cannot find correct answer by average, if condition must be in every cell.....

    • @paraninathan
      @paraninathan 3 года назад

      correct

    • @ajeetrathore122
      @ajeetrathore122 3 года назад

      Govt hospital me cleark ka kya work hota hai is per sir vedio banaye please sir kaise work karte hai

  • @testknowledge1292
    @testknowledge1292 3 года назад

    How can find out ?
    More than 33% and fail because one subject mark less than 30.

  • @hussainansari2058
    @hussainansari2058 3 года назад

    Subject me fail rahne se or 33 percentage aa jane se wo pass thode na ho jate hai.

    • @hussainansari2058
      @hussainansari2058 3 года назад

      Mera kahna hai sir yadi kisi v subject kam number ata hai wo us sabject me fail rahta hai lekin uska percentage 33% se jayda rahta hai to apke anusar wo v pass ho jayega na.

  • @indofacts.
    @indofacts. 4 года назад

    sir apna whatsapp no. dedo mere leptop me error aa rahi hai

  • @rdxayush3.o
    @rdxayush3.o 3 года назад

    Formula is worng

  • @Tracks777
    @Tracks777 4 года назад

    lovely video

  • @Tracks777
    @Tracks777 4 года назад

    lovely content

  • @Tracks777
    @Tracks777 4 года назад

    awesome video