How to use IF, AND, OR Functions in Excel (हिंदी में) | MS Excel IF Function | IF Formula in Excel

Поделиться
HTML-код
  • Опубликовано: 27 сен 2024
  • In this you will learn How to use IF, AND, OR Functions in Excel. You can also learn complete Digital Marketing Free through our RUclips channel in Hindi.
    Also it helps our client in discovering ecommerce product to boost and shot up the sales and make big profits .
    If you are the one who want to make big money in digital marketing then it is a must tool.
    Best Web Hosting Service Provider
    1. BlueHost - bluehost.sjv.io/YgVkOj
    2. Hostinger - www.hostg.xyz/...
    Best SEO Tool
    1. Semrush Pro Trial - semrush.sjv.io...
    2. Semrush Guru Trial - semrush.sjv.io...
    #msexcelcourse #iffunction #hiteshgupta

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

  • @Hinata.033
    @Hinata.033 Год назад +34

    Thank you so much sir 😌
    Bcuz of u thousands of students can learn professional skills only for free
    , Once again thank you 😊

  • @amandeep7919
    @amandeep7919 8 месяцев назад +45

    Please play back speed *1.75 kar dena nahi to irritate ho jaoge

    • @druvaclan
      @druvaclan 7 месяцев назад +4

      mene toh 2x rakhi hai aur fir bi ho jata hu

    • @navneetyadav1553
      @navneetyadav1553 6 месяцев назад +9

      Sekh liya ho to thank you bol do sir ko...🤔

    • @md.alikhan8238
      @md.alikhan8238 6 месяцев назад

      ​@@navneetyadav1553aap to married lag ri ho..aap q Sikh ri ho😅

    • @Ahmedtalat006
      @Ahmedtalat006 4 месяца назад

      😂😂

    • @SScASPIRANtSANDIP
      @SScASPIRANtSANDIP 4 месяца назад +4

      ​@@md.alikhan8238 Education ki koi age limit nhi hoti bro thoda samjha Karo ❤

  • @kiranmina6430
    @kiranmina6430 Год назад +4

    Hlw sir you are the best trainer I'm amazed u made learning so simple easier with fun thank you so much

  • @knowledgezone998
    @knowledgezone998 Год назад +2

    Bahut hee accha se samjhaya jata hai, bahut bahut dhanyawad sir 🙏🙏🙏

  • @edully1181
    @edully1181 Год назад +6

    What a course really nice 👍

  • @nayakya1957
    @nayakya1957 Год назад +5

    Respect for your content 🙏

  • @shashisharma2673
    @shashisharma2673 28 дней назад

    Thank you for this useful information 🙏

  • @vinayak3874
    @vinayak3874 Год назад +3

    AMAZING SESSION SIR JI

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

    Thankyu sir really understanding vedio...❤ sach me aap achi vedio bnate..

  • @Sheetalmahartech97
    @Sheetalmahartech97 11 месяцев назад +1

    Thanks sir for this online course

  • @Mandeep.kumar.77
    @Mandeep.kumar.77 4 месяца назад

    Your lectures are so helpful, sir !

  • @ajitjadhav8794
    @ajitjadhav8794 10 месяцев назад

    Learning amazing things bcz of you. Thank you

  • @zeeshantalib-u3o
    @zeeshantalib-u3o Год назад +1

    AMAZING COURSE . YOUR TEACHING STYLE IS GREAT . THANK YOU SIR

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

    Mast video acche se smj aaraha h

  • @SarveshKumar-xn8um
    @SarveshKumar-xn8um 2 месяца назад

    Thank you so much sir, your teaching skills are really appreciable,, but sir I have some confusion in the part of grade, there is results something different

  • @messikaka7291
    @messikaka7291 21 день назад

    Please sir giving easy formula for result

  • @Krishnakumar-zq9ei
    @Krishnakumar-zq9ei Год назад

    Thank you sir Apne ki Bari problem solve krdi❤❤

  • @khushiwadhwani4589
    @khushiwadhwani4589 2 месяца назад

    Thank you sir!

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

    If I learn this IF,IF AND there will be any use for working in a company

  • @haider3433
    @haider3433 2 месяца назад +1

    agr bnda percentage dekh k likh dy to kafi time bch jaye gha 😅

  • @ashutoshvidyarthi13
    @ashutoshvidyarthi13 10 месяцев назад +1

    Mja aa gya sir jee

  • @TarabaiBansode-d3g
    @TarabaiBansode-d3g 3 месяца назад

    Thank you so much sir 🙏🙏

  • @aagyajain
    @aagyajain 5 месяцев назад

    Thanks a lot sir..🙏🙏

  • @angmotse9046
    @angmotse9046 Год назад +3

    Sir my result and grade formula is not working so any solution for it???

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

    Very important videos sir

  • @PravinPatel-s8s
    @PravinPatel-s8s Месяц назад

    Sir suplimentry ka liye kese formula put karnge

  • @navneetyadav1553
    @navneetyadav1553 6 месяцев назад

    Thank you sir 🙏

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

    Highly helpful...👍

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

    Amazing sir❤

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

    U r the best

  • @mansisharma-k1d
    @mansisharma-k1d 2 месяца назад

    HELLO SIR MENE YE APPLY KIYA PR YE ISME LG HI NI RHA ERROR BTA RHA H PLEASE HELP ME K MAI KHA GLT HO RHI HU =IF(AND(D3>=33,E3>=33,F3>=33,G3>=33,H3>=33),''PASS'',''FAIL'') AND THANK YOU SO MUCH FOR TEACHING US UR WAY OF TEACHING IS VERY GOOD.

  • @c.d5970
    @c.d5970 10 месяцев назад

    THANK YOU SIR JI

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

    Bout Pasand aya g

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

    EXCLLENT WORK

  • @SrimantaPramanikOnefocus
    @SrimantaPramanikOnefocus 4 месяца назад

    It is really helpful video.

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

    Thank sir

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

    Helpful video 🎉

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

    Thanks sir

  • @Qaisar_khan1998
    @Qaisar_khan1998 11 месяцев назад +1

    Sir can we use IF for whole row and colum Please

  • @chhatpatimasti5585
    @chhatpatimasti5585 11 месяцев назад

    Actually i am try to put this formula in this to do like i want to apply two conditions on sat and sun will mark w/o and rest day P

  • @Rolex1253
    @Rolex1253 Месяц назад +3

    2x m dekhne wale like kre 👍☑️

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

    Nice

  • @anupamamaharjan921
    @anupamamaharjan921 2 месяца назад

    Thank u for sharing the video. I am not able to get IF IF formula correctly. Showing ERROR as #NAME?. Please could you rectify my error for below formula:=IF(Q3=FAIL,"F",IF(N3>=75,"A+",IF(N3>=60,"A",IF(N3>=45,"B",IF(N3>=35,"C")))))

  • @talhanazir341
    @talhanazir341 Месяц назад

    if if wali sari example solve k doran screen blurr hi rhi kuch nzr nhi aya

  • @BholaShah-q1x
    @BholaShah-q1x 3 месяца назад

    ❤❤

  • @sudhanshutech20
    @sudhanshutech20 6 месяцев назад +1

    Sir Javascript se toh easy hi hai yeh 😢😢

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

    Sir apne 39%vale ko pass kar rakha hai or 49 % vale ko fail asa kyu

    • @goutambakshi6097
      @goutambakshi6097 10 месяцев назад

      Because 49% wala ek subject me fail hai dhyan se dekhe... hindi me uski marks 29 hai ... or sutra ke anusar 33 no ke niche wala fail hai

  • @shilpdhande
    @shilpdhande 4 месяца назад +2

    Summary:
    IF use
    IF(F12>=33,"PASS","FAIL")
    IF AND use
    IF(AND(C2>=33,D2>=33,E2>=33,F2>=33,G2>=33),"PASS","FAIL")
    IF OR use
    IF(OR(C2

  • @nakulgoyal3630
    @nakulgoyal3630 4 месяца назад

    Sir mai end meri remarks dena cha raha hu jaise jiska A+ aya usko excellent,C aya toh very poor, usi formula se jisse grades diye hai lekin error show ho Raha hai har baar.

  • @AyushDhakal-lj9ej
    @AyushDhakal-lj9ej 11 дней назад

    Ms excel sikh k kuch kam milega kya

  • @kiranakhtar3994
    @kiranakhtar3994 6 месяцев назад

    If we learn only one rule that would be enough bcz all are being used for same purpose

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

    Hello sir meri grade column m value false aa rahi he kyo plz give m suggestions.

  • @ShauryaThakur-ov2zr
    @ShauryaThakur-ov2zr 3 месяца назад +1

    Need 4x

  • @RituChaudhary_Official
    @RituChaudhary_Official 4 месяца назад

    Sir my result formula is not working plz solution

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

    Sir yeah grade waly mn error ata hai formula mn value Ka puchta hai JB Kay ap Jha seikha rhy hai wha enter krty hi grade c ajata hai JB Kay yha value b Puch Raha yh smj ni aya

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

    Why not only IF?

  • @illigal-crazy-parkour
    @illigal-crazy-parkour Год назад

    SIR IF IF NAHO HO RAHA HA PLZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ CLEAR THIS

  • @abhishekshukla1443
    @abhishekshukla1443 4 месяца назад

    My if and formula is error what do i do plzz

  • @MayankSharma-ki8kj
    @MayankSharma-ki8kj Год назад

    sir sarre function krvao yeh toh 10 percent hai bus concatinate, left toh krvaya he nhi

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

    SIR IF IF FORMULA IS NOT WORKING ON MICROSOFT 365

  • @internationaldiamondimport2608
    @internationaldiamondimport2608 2 месяца назад

    Hi

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

    sir khudi pass or fail likh skty itny formula lgany ki kia zrort h?

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

      To save your time when you get many students marks what will you do you?will you write all of them pass or fail or just you can write the formula for one and apply all for the same.

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

    Sir if and wale concept me parsentage me sab 33se above he fhir vha fail kyo aaya

  • @MuhammadUsman-m8e7x
    @MuhammadUsman-m8e7x 3 месяца назад

    Sir muja ap ka "IF AND" aur " IF OR" ma koi pata nai chala ka ap kia samjhana chah rahe ha. Mara khiyal ma ap ko khud b clear nai ha ka dono ma kiya diff ha.

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

    Why using IF AND IF OR?

  • @ranazain4732
    @ranazain4732 2 месяца назад +1

    Tooo difficult kuch samjh ni aya😢😢😢😢😢

    • @TheKumarmanoj
      @TheKumarmanoj 16 дней назад

      C programming mein padhaya tha ye sb...isiliye condition smjh aaya ..

  • @tanishkavarshney6499
    @tanishkavarshney6499 Год назад +3

    I applied last formulae if if one wala...yhn likha aara h....u have applied too many argument that for this function... What should i do...and where i m wrong... Olz guide

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

      Same problem I'm facing in IF AND function........ it's giving an error

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

      Pls help me if u have sorted this error

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

      ​@@raoaman1364apply formula properly,

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

      At the Time of applying condition don't use double inverted commas sign

    • @xledits-w8c
      @xledits-w8c 8 месяцев назад +1

      Use this formula it is easy and you will easily understand it and there is no error in it.....
      = if (L8 >= 90,"A", if (L8 >= 80,"B", if (L8>=70,"C", if (L8 >= 60, "D", if L8>= 50,"E", "F")))))

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

    19:20 39.2 wala pass or 49.4 wala fail kaise ho gya.

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

      EXACTLY

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

      Kyu ki 39.2 wale ke kisi bhi subject me marks 33 se kum nhi the dusri taraf 49.4 wale ke hindi me 29 hain mtlb 33 se kum isliye wo fail h

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

    sir it is coming you enter too many arguments for this function

  • @sagarchhatri6868
    @sagarchhatri6868 6 месяцев назад

    Sir 49 toh pass hota Hai na I m right ❤

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

    Last vala nahi hua meraaa 5 brr try kia😢

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

    49.4 PAR PASS HONA CHAHIYE ISME ERROR H PLZ SOLVE OTHERWISE DATA IS WROUNG

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

      Student E has 29 marks in Hindi. He has less than 33 marks in that subject hence why he has failed. IF AND statement is applied to individual subjects, not the overall percentage.

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

    sir ek problem ari ha ma safe formula dalra hu lekin har value ka result fail hi nikal rha h

    • @mannygill705
      @mannygill705 4 месяца назад

      facing same issue, I don't know even how to resolve it.

  • @AmanSharma-ib8xx
    @AmanSharma-ib8xx 2 месяца назад

    Or and me galti kr diye🙂aap

  • @Golupandey-e4j
    @Golupandey-e4j 2 месяца назад

    49% kaise fail aa raha h sir, vo toh pass hona chahiye na

    • @aamnamazhar6984
      @aamnamazhar6984 2 месяца назад

      Kyuki uske hindi mai 29 marks hai vo hindi mai fail hai pass hone ke liye minimum 33 marks hone chahiye thai

  • @Nikhilpandey_designer
    @Nikhilpandey_designer 4 месяца назад

    PR wo 49.4% ke baad bhi fail😅

  • @SANKALPSINGH-m1c
    @SANKALPSINGH-m1c 3 месяца назад

    If or ka kya fayda...ye kaam toh if and me bhi hota hai 😅

  • @yogeshyadav9199
    @yogeshyadav9199 Год назад +2

    information thik he lekin dimak bhot kharab kiya

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

    CLASS 8TH COMPELETED

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

    Thanks u sir

  • @RahulPohekar
    @RahulPohekar 2 месяца назад

    Sir less than ka formula muzhe kuch bhi samzh nhi 😒aya? =If (or (34

    • @RahulPohekar
      @RahulPohekar 2 месяца назад

      Jab vo values true hai to fail qu ana chahiye sir . Or fail hai to true qu ana chahiye ? Jab ki value to same hi nikalni hai app less than karo ya greater than karo 🤯

  • @newsong941
    @newsong941 13 дней назад

    If , if and, if or, if if ye 4 condition ku h 1 baar me hi to result aa gaya abb baar baar result ku nikal rahe ha

  • @indprachi8976
    @indprachi8976 27 дней назад

    SIR IF OR MAI CONDITION MAI EQUAL TO KA USE KYU NHI HA
    IF(OR(C2

  • @tirtharajbanerjee
    @tirtharajbanerjee Год назад +17

    So difficult concept explained in simple language! Great learning experience!!!! Thanks Sir.

  • @VishalThakur-b6z
    @VishalThakur-b6z 8 месяцев назад +1

    Sir IF and formula is not working, pls help

  • @newsong941
    @newsong941 13 дней назад

    Kuch samaj nahi aya ki result nikal ne ka 4 tarika h

  • @yashojha5748
    @yashojha5748 День назад

    SIR POWER POINT KA FULL COURSE LAYE

  • @puneetbhardwaj9011
    @puneetbhardwaj9011 Год назад +3

    Can we also calculate this with the help of the total column

  • @shamisammi7331
    @shamisammi7331 Месяц назад +2

    Bohat hi kam ki chez ha mashallah

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

    Sir kya and formula greater then ke sath lagna hai ya less then ke
    Kai log bolte h greater then ke sath lagta h
    Answers me

  • @Navee.ntiwari_19
    @Navee.ntiwari_19 Год назад +11

    Sir mai daily aapki hi videos se sikhta hu,, thanks sir ji itna acha se btane ke liye 😊

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

    Sir I want to ask which MS Excel version u r using.

    • @snehilsparsh2625
      @snehilsparsh2625 Год назад +2

      Just appreciate him then he only reply you 😂

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

    Sir condition apply karne se acha to mey khude dekh k fail,pass typing kardu, time v bachega

  • @freecrickstats
    @freecrickstats 7 месяцев назад +2

    Sir aap bahoot acha se detail me samjhte hain bahoot acha lgta hai apaka teach ka tarika

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

    everything is thax giving but sound is little bit low....I need to use head phone

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

    if if wala formula mere PC me error bta rha h sir koi solution btaye sir

  • @HarshGupta-xm8jo
    @HarshGupta-xm8jo Год назад

    Sir mera if (and) wala postion red dikha raha hai enter kerne ke bad

  • @msrvideographer1919
    @msrvideographer1919 11 месяцев назад

    Sir Har jagah certificate mangta hai uska kya kare

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

    Wonderful✨😍.. Course...
    Thank you🙏❤