EXCEL IF FORMULA :Part 2 | Ms - Excel if function in hindi

Поделиться
HTML-код
  • Опубликовано: 10 ноя 2024
  • Excel amazing if formula
    We cover a few examples including
    1. Simple if function
    2. IF function with formula inside
    Basic Excel Playlist Link - • Basic Excel-The Learni...
    Download the Assignment Master Practice Folder here (All Playlist Example at one place)
    drive.google.c...
    ===========VIDEO COURSE============================
    ✅ Mastering Excel Video Course
    www.innozant.c...
    ✅ Mastering Power BI Video Course
    www.innozant.c...
    ✅ Mastering VBA Video Course
    www.innozant.c...
    ✅ Mastering SQL Video Course
    www.innozant.c...
    Visit - innozant.com
    =====================================================
    ===========HYBRID CLASSES============================
    ✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
    ✅ Database Training(SQL , PL\SQL , Oracle Developer)
    ✅ Mastering Data Science
    Visit - innozant.com
    ====================================================
    Videos in a Sequence -Basic to Advanced EXCEL
    Basic Excel- • Basic Excel-The Learni...
    Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
    Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
    Excel What if Analysis- • Excel What if Analysis
    Excel Array and Sumproduct- • Excel Array & Sumprodu...
    Excel Lookup Functions- • Excel Lookup Functions...
    Excel Pivot Tables- • Excel Pivot Tables
    Excel Power Pivot- • Excel Power Pivot
    Excel Power Query- • Excel Power Query
    Excel Chart and Infographics- • Excel Chart and Infogr...
    Excel Dashboard & Reports- • Excel Dashboard & Reports
    Value add-ons Playlist
    ProQuest-Check Point- • Excel ProQuest-Check P...
    Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
    StudsTalk -The Journey begins- • StudsTalk-The Journey ...
    QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
    Excel Tips and Tricks- • Excel Tips & Tricks
    MIS Interview Cracker- • MIS Interview Cracker
    MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
    Excel Maharaj- • EXCEL MAHARAJ - For Ex...
    Microsoft Powerpoint- • Microsoft Powerpoint
    Microsoft Word- • Microsoft Word
    Office 365- • Office 365
    Google Sheets- • Google Sheets
    Microsoft Outlook- • Microsoft Outlook
    Power BI- • Power BI
    Excel VBA- • Excel VBA Macro
    TezXL Jata Shorts- • #shorts | जो TRIM के ब...
    Announcements- • Announcements
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantinfotech
    Facebook ► / innozantinfotech
    Telegram►t.me/innozanti...
    #Ifformula #msexcel #logicalfunction #excelvideo #datascience #innozant

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

  • @Pyaritapasya36
    @Pyaritapasya36 7 месяцев назад +1

    Sir itna acha kaise padha lete ho , means basic maths me bhi problem hoti hai but apne itne easily ek ek step wise sab khuch smjhaya jo pehle nhi samjh aa rha tha but apne clear kr diya thankyou so much sir really Dil se thankyou sir ❤

    • @Innozant
      @Innozant  7 месяцев назад

      Thanks..Keep learning

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

    Itne dino baad bhi aapka padhaya huaa abhi tak mind me hai ye video dekh ke or ache se aa gya

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

    Hi Sir, Your way of teaching is very nice, aap bhut ache se explain krte hain example deke, and one more thing is this that ki aap bhut easy and normal language mein samjhate hain.... Thank you this...

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

      Thanks Nikhil Ji Aapke valuable appreciation ke liye dear..Keep learning 👍

  • @sandeeppandey5663
    @sandeeppandey5663 7 месяцев назад

    Bahoot badhiya approach hai sir ji lsikhane ka .
    Aur aapka bolne ka style bhi ekdum mast hai boring bilkul nahi lagta.

    • @Innozant
      @Innozant  7 месяцев назад

      Thanks.Keep learning

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

    Sir apne mast samjaya hai.you are great teacher.humhe palhe if samaj nhi aata tha sir.yeh video ko mai sabhi gagah share karunga.thanks

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

      Thanks 👍❤️

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

    good morning sir ❤️

  • @RA-rh5lb
    @RA-rh5lb Год назад

    Thank you very much Sirji.. great teaching. If a person like me can glue to excel then there must be some miracle. Like tho lakho banthe hai.. my humble pranam ..

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

      Thanks dear.Really means a lot to me.God bless You

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

    SIR,I AM FOLLOWING YOUR VIDEOS WHICH ARE VERY HELPFUL TO ENHACED SOMEONES KNOWLEDGE BOTH THEORITICALLY AND PRACTICALLY. I WANT TO REQUEST YOU PLEASE UPLOAD A VIDEO ON "HOW EXCEL CALCULATES" I.E. IF IN A FORMULA THERE ARE + -* / ALONG WITH ( ),{ } THEN HOW EXCEL ARITHMETICALLY CALCULATES. HOPE YOU UNDERSTAND MY POINT. IF YOU HAVE ALREADY POSTED SUCH TYPE OF VIDEO PLEASE SHARE THE LINK. THANK YOU AND WISH YOU ALL THE BEST.

  • @muhammadsadiq8885
    @muhammadsadiq8885 8 месяцев назад

    Very good teaching style.

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

    so nice sir love .. kash maine aaap k lectures phle dek laita tu ...bahot expert ho jata...

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

      Koi baat nahi..step by step seekhte rahiye..bht acha ho jayega skills dear

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

      @@Innozant सिर अआप ने किस तरह सेखा था और अआप का नाम किया है सिर ।।मुजे देशोबोर्ड एक्सपर्ट बनना चाहता हूँ अआप की तरह तू गुरु जी मेरा मार्ग दर्शन करते रहैगा

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

      humesha dear..Happy learning

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

    Good Teacher👍👋

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

    Thanks you very much for providing excel training to every excel work lovers and Keep going ahead and I will see more and interesting videos from you. All the best!!!

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

      Thanks Kiran ♥️🙏 Happy Learning dear ❤️👍

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

    Hii sir aap bhot aache sa samjhate ho thank you sir

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

      Thanks Preeti..step by step in sequence Seekhiye aur practice kriye..ache profile par switch kr jayenge ydi QUIT Nhi kiye to

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

    Sir samajh aa gya bohut hi esly

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

    superb video dear sir ji

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

    Good Explanation..Thanks for posting such a wonderful excel video

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

    Wow❤❤❤ what a class ❤️good job sir

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

    Beautiful guruji

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

    Excellent, thank you sir

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

    Excellent, enjoying for learning

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

    Thank you so much sir your teaching skill is very good

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

      Thanks 🙏🙏❤️

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

    Learning a lot from your video . thanks a tones

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

      Thanks dear..Good night 🙏❤️

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

    Thanks sir for teaching if condition,

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

    Sir naariyal chhil k smjha diy a yhnx u sir

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

      Hahahaha...Thanks dear...God bless you..Happy learning

  • @arundubey-y4d
    @arundubey-y4d Год назад

    excellent

  • @M.Saqlain90-6
    @M.Saqlain90-6 3 года назад

    Very Greatful Work

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

    Wow sir exactly what I needed thank u so much .

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

    You are awesome sir...nice way of teaching..

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

      Thanks Sushma,We welcome you to experience the taste of success,We recommend you to start your learning series with Playlist Basic Excel-The learning begins (videos in sequence playlist available in latest video description)
      Thanks for being part of Innzant family

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

      @@Innozant yes sir I am watching ur all video...😊

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

      🙏🙏❤️❤️

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

    Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen

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

    Sir please upload macro and VBA class

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

    Excellent video

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

    Very good sir

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

    good ho gya sir g

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

    Sir "F9" se formula me value dekh sakte hai but agar sirf se wasap aana hai to kya kre ge?

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

      Undo ctrl z or ctrl g

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

      @@Innozant Got it sir actually when i open the many sheet then this was not working

  • @akashkumar-oi1fw
    @akashkumar-oi1fw 4 года назад

    gd mng sir if formula file practice folder mai nahi hai plz uske example ki file add kar do

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

      Basic excel folder me hai saare example ..kindly check..waise ye to bht simple hai format Bana lijiye khudse bhi formatting ki Practice bhi ho jayegi aapki

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

    CGL-AM/00000100
    CGL-EL/00000187
    Sir mujhe jaha par "AM" he dusri column me auto aana chahiya and "EL" me electrcial chahiya kya ye formula se possible he.
    possible he to please.

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

    Thnq sir

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

    K Sir!

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

    Sir how you can see the value in formula bar ex- =IF(C2>5000,C2-C2*10%,C2-C2*5%) jaise c2-c2*10% ya value kitna hai how we can see?

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

      Select formula and press F9

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

      @@Innozant k sir! Thank you!☺️

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

    👍🏻👍🏻👍🏻👍🏻👍🏻

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

    =IF(F40>5000,F40-F40*10%,"no discount")

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

    Classical teachin

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

    koi reesh nhi inki😂😂

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

    मैंने C2 का 90% कर दिया ये चल जायेगा गुरुजी ।

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

      Means ?kausna value change Kiya aapne

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

      c2-c2*10% ना लिखकर इसकी जगह c2*90%