MS Excel - IF Function

Поделиться
HTML-код
  • Опубликовано: 22 янв 2025

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

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

    To Get Certification, Click Here: bit.ly/38Jyu3p
    Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.

  • @ZhouFinLau
    @ZhouFinLau 2 года назад +30

    This did more for me in 5 minutes than what I learnt for 5 hours, from my college computer lab. Thank you boss❤

  • @kamalhugsyou
    @kamalhugsyou 4 года назад +73

    I completely like the way you explain. Though I am good in excel, i never had quality of explaining my knowledge to others. I am suggesting your videos to all my staffs after comparing others tutorial. Keep updating more and more.

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

      I WILL LIKE TO ASK FOR YOUR HELP IN EXCEL

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

      Could uh share your no.plz
      SOS

  • @AmirKhan-hy9pr
    @AmirKhan-hy9pr Год назад +6

    You're one of the best teachers I've ever seen specially in Computer Education. Thank you very much Sir

  • @ConsiousMind1
    @ConsiousMind1 7 месяцев назад +5

    Really bro, You juzz made me amaze !!! May Allah grant you, your precious family, your friends Hidayah soon and keep u all safe n healthy......Ameen.

  • @alinurmohamed5304
    @alinurmohamed5304 3 года назад +4

    There're more inside YOU. Something I've been looking for decades Mr. Pavan. I will be a lifetime student of yours. Many thanks

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

      Haye, Muddo 6 bilood ka hor baad aragtidan dhiibataye, macallin ma ku noqotay bahalka ugaas?

  • @Swarabarna.harmonica
    @Swarabarna.harmonica 2 года назад +10

    No intro, no drama bazi..
    I Appreciate your efforts😗
    Thanks for all type of possible if functions 👍

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

    Sir, You have made learning excel so simple, quick and easy. What I don't understand in my class, I refer to ur videos and clarify my doubts. Thank you so much:)

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

    Came across your videos. I am not too computer savvy but understanding you was a breeze. Thank you so much.

  • @savariappan.alphonsa7897
    @savariappan.alphonsa7897 2 года назад +8

    Sir, your classes are simple and easy to understand. I always refer your classes especially with functions. Thank you so much!

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

    Best excel learning videos ever seen. Kudos

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

    Thanks sir. Even classes teachers who takes money from us can not teach like you. Great videos of excel.

  • @shriidharkulkarni6648
    @shriidharkulkarni6648 3 года назад +3

    Excellent. You make learning Excel more and more interesting for everyone. Keep up the good work and release such interesting videos more often. This video is three years old.

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

    Omg video created in 2016 still better than current videos on excel

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

    Thank you sir u using simple English i understand very very easy thank you again sir

  • @yogawithnaga2697
    @yogawithnaga2697 2 года назад +5

    Awesome Explanation Bro 👏👏👏👏Thank you so much for imparting this knowledge 🙏

  • @MukeshGupta-sl6yi
    @MukeshGupta-sl6yi 5 лет назад +7

    Love you sir...such a simple method of teaching which I really liked it🔥🔥🔥

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

      ⭐⭐ MICROSOFT EXCEL COURSE TO SKILLUP⭐⭐
      ADVANTAGE OF THESE COURSES
      01. REAL WORLD EXCEL PRACTICAL EXCEL SHEET
      02. COMPLETION CERTIFICATE WILL BE PROVIDED
      03. BEST DISCOUNTED PRICE
      04. LIFE TIME ACCESS TO THE COURSE
      05. MORE THAN 32000 ENROLL THESE COURSES WITH IN TWO MONTH
      01 MOST ESSENTIAL AND POPULAR MICROSOFT EXCEL FORMULAS AND FUNCTIONS.
      www.udemy.com/course/most-essential-popular-excel-formulas-and-functions/?couponCode=5766ADD876645FAEEACD
      Coupon Code - 5766ADD876645FAEEACD
      02 ADVANCED MICROSOFT EXCEL FORMULAS AND FUNCTIONS
      www.udemy.com/course/advanced-microsoft-excel-formulas-functions/?couponCode=5AE0A4858DC79FBDF931
      Coupon Code - 5AE0A4858DC79FBDF931
      03 THE COMPLETE MICROSOFT EXCEL PIVOT TABLES AND CHARTS
      www.udemy.com/course/the-complete-microsoft-excel-pivot-tables-and-pivot-charts/?couponCode=8CA1F7CDC5F9B5DB0F45
      Coupon Code - 8CA1F7CDC5F9B5DB0F45

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

    Dear Pawan ,
    Thankyou so much for making excel so easy for novice like me

  • @Luqman.Khawaja
    @Luqman.Khawaja 4 года назад +1

    Hurray! I got the basic concept of "If" function and applied in my excel sheet. It works. Very easy to understand.
    Thanks - Teacher
    Respect from Pakistan

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

      ⭐⭐ MICROSOFT EXCEL COURSE TO SKILLUP⭐⭐
      ADVANTAGE OF THESE COURSES
      01. REAL WORLD EXCEL PRACTICAL EXCEL SHEET
      02. COMPLETION CERTIFICATE WILL BE PROVIDED
      03. BEST DISCOUNTED PRICE
      04. LIFE TIME ACCESS TO THE COURSE
      05. MORE THAN 32000 ENROLL THESE COURSES WITH IN TWO MONTH
      01 MOST ESSENTIAL AND POPULAR MICROSOFT EXCEL FORMULAS AND FUNCTIONS.
      www.udemy.com/course/most-essential-popular-excel-formulas-and-functions/?couponCode=5766ADD876645FAEEACD
      Coupon Code - 5766ADD876645FAEEACD
      02 ADVANCED MICROSOFT EXCEL FORMULAS AND FUNCTIONS
      www.udemy.com/course/advanced-microsoft-excel-formulas-functions/?couponCode=5AE0A4858DC79FBDF931
      Coupon Code - 5AE0A4858DC79FBDF931
      03 THE COMPLETE MICROSOFT EXCEL PIVOT TABLES AND CHARTS
      www.udemy.com/course/the-complete-microsoft-excel-pivot-tables-and-pivot-charts/?couponCode=8CA1F7CDC5F9B5DB0F45
      Coupon Code - 8CA1F7CDC5F9B5DB0F45

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

      hurry? I think you mean Hurray

    • @Luqman.Khawaja
      @Luqman.Khawaja 2 года назад

      @@shaayeqparvez4551 Yes, spelling mistake. Thanks

  • @56davidpantagada60
    @56davidpantagada60 3 года назад +1

    Thank You So Much Pawan Sir!
    May God protect you and your family in this pandamic.
    And I LIKE your way of explaination. THANK YOU FOR YOUR EFFORTS

  • @dankalunga2483
    @dankalunga2483 4 года назад +4

    This guy has a way of explaining this stuff in a simple way... Such a great tutor!!?

  • @luckysuniqueness5921
    @luckysuniqueness5921 5 лет назад +1

    You are making videos in such a useful manner. Thanq very much for ur efforts.

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

    SUPER SIR, LIKE YOU ARE PROFESSOR IN UNIVERSITY.

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

    Pahli baar main kisi ki puri English samjh pa rha hun 🤗
    Thanks sir

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

    Thanks Pavan Sir. This videos are very simple and helpful.

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

    Ur looking like Sonu Sood from side (thumbnail) 💜💜

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

    your way of explanation is really awesome and easy to understand...

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

    You are amazing at Excel. I am learning so much from you. Keep it up

  • @SandeepSharma-f8p
    @SandeepSharma-f8p 8 месяцев назад

    Very efficient in the simplest way!

  • @pravindhangar674
    @pravindhangar674 5 лет назад +3

    Sir, your every videos are very important. I have been trying to watch them not miss them. I have been learning a lot about Excel through these videos. Thanks

  • @Usman-ml4ig
    @Usman-ml4ig 5 лет назад +3

    God bless you, dude - you have a talent to teach lucidly. I like your clear accent too.
    Love for Pakistan.

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

    Very nice explanation...It is making learning excel so easy

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

    Thanks😊 it's so much helpful ...

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

    Thank you very much Mr. Pavan for explaining well as usual.

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

    Thank you so much
    your all videos are too good & easy to learn

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

    Good sir your way of teaching superb..

  • @RA-rh5lb
    @RA-rh5lb 5 лет назад

    One of the best trainer

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

    Sidhi baat no bakwaas 😍🥰🥳

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

    The way of explanation is very nice

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

    Sir tahan sutha teacher aayo- love from sindh

  • @wrestling2ber251
    @wrestling2ber251 5 лет назад +1

    You looking very smart and your teaching very awesome

  • @saraliseth
    @saraliseth 5 лет назад +1

    Thank you so much!!! I watched like 4 videos before yours and this gave the best explanation! thank you!! My formula came out finally!!!

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

    If Function made easy. Good explainer

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

    Thank You Sir, God Bless You and Your Family, Please take care due to Corona Virus Outbreak.

  • @NavneetSingh-yf2bf
    @NavneetSingh-yf2bf 3 года назад

    Superb, you are the best

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

    Superb explanations..simple and powerful

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

    Mujhe ye video aaj mili aur upload 6 year phele ka h kya mst padha raha h bhai yrr

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

    Thank you Sir , you explaned it very well

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

    Amazing tutorials, simple and easy learn

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

    Good presentation . Easy to understand

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

    Excellent explanation...!

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

    Very good class, clear and useful

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

    Nice explained. Thnx 😊

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

    EXCELLENT ANALYSIS AND METHODS OF TEACHING.

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

    Very clear explanation thanks

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

    your teaching skills are amazing.. great tutorial #TrixCorner

  • @kunalmandlekar32
    @kunalmandlekar32 5 лет назад

    Hi Sir,
    Thanks for the videos. explained in detail which helped to understand very easily. Thanks alot...............

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

    Super :)
    Thank you Master.

  • @MuhammadIbrahim-xb1tr
    @MuhammadIbrahim-xb1tr 5 лет назад +2

    Sir learnt a lot from you thanks sir g

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

    Wow great work ✌👌

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

    Hi sir, The way of explaining was Awesome!!!
    As i what learnt in the Excel, all credit goes to you. Really Thank you from bottom of my Heart

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

    Very helpful channel. Thank you sir

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

    Sorry for coming 5 years late but thank you for this teaching

  • @gurpreetkaur-zr1qj
    @gurpreetkaur-zr1qj 3 года назад

    Great man👏👏👏

  • @balukayande4626
    @balukayande4626 5 лет назад

    Excellent sir. Very very nice teaching skill

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

    your pedagogical skills are absolutely brilliant

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

    Straight to point

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

    Thank You so much SIR 😊

  • @kasundpathirana-basic8549
    @kasundpathirana-basic8549 2 года назад

    Thank You So Much... ❤️👌😋

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

    excellent video and Easley we can understand

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

    Very excellent explanation

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

    Nicely taught! It cleared my multiple doubts.

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

    great it's very easy. thanks a lot...

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

    hi sir, if numer also contain text for exmple, 10g, 300ml can we use if formula. i am trying to use but not working. i am using =IF(A1

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

      Hi Samir,
      In My opinion, You cannot perform a mathematical operation on 10g/200ml. You can perform mathematical operation on numbers. Hence, each time, MS Excel is giving You "b".
      1st, You will have to segregate number. Then, You could use a Formula.
      For further support, please contact on goodnessshallprevail@gmail.com.
      Thank You!

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

      @@ankursharma6157 thanks for reply sir

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

    THANKS FOR TEACHING US .

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

    You explained so nicely sir !

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

    Thank you sir good explanation

  • @m.antonraneshaperera283
    @m.antonraneshaperera283 4 года назад

    Your explanations are really impressive. weldone sir.

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

    Thank you so much it's very helpful ❤️

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

    Out standing sir

  • @pupinamelon5887
    @pupinamelon5887 5 лет назад

    Thank u indian man.

  • @PoojaSharma-gv8dr
    @PoojaSharma-gv8dr 5 лет назад +1

    I. Like your all video and i can easily understand

  • @dsroutdoorhunt2750
    @dsroutdoorhunt2750 6 лет назад

    Nice... Really... The explanation was too good

  • @MuhammadIbrahim-xb1tr
    @MuhammadIbrahim-xb1tr 5 лет назад +2

    Thanks sir thanks for your sharing knowledge

  • @memewallah582
    @memewallah582 5 лет назад

    Good master's of india

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

    Explained really well. Great job.

  • @saifurrahman6060
    @saifurrahman6060 5 лет назад +7

    Amazing Videos.
    Hello! Can you please make a video to show how to use *Sum if" and "Count if" in excel...

  • @sakhiahmadjan4355
    @sakhiahmadjan4355 5 лет назад +1

    Thank u for sharing ur knowledge..

  • @itspoojaaly
    @itspoojaaly 5 лет назад +4

    can you tell how to fetch price of stock from nse at regular interval say 5 minutes, like
    9:15 189
    9:20 187.55
    9:25 188.65 and so on so that change can be calculated at regular interval.
    Hope to get a response. Thanks in advance.

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

      i guess you directly came from stock market turorial?

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

      @Asit Kumar NO Mr Asit wrong. I came here because i am working on my Automated trading system

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

      @Asit Kumar after hearing this I am surprise and at the same time I am on the seventh heaven ☺️☺️

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

      Did u find answer if yes could you tell me pl

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

      Yes I did..it's bit lengthy and the answer is vb coding , but working fine for my analysis

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

    Well explanation.thank u

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

    pwoli machaane thank you

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

    hello dear...first of all thanks for the lovely videos...
    also i am very eager to know the source of such profound knowledge, which covers such detailed knowledge....

  • @manjit._.1430
    @manjit._.1430 4 года назад

    Thank you sir💚🙏

  • @Star-vg7ix
    @Star-vg7ix Год назад

    very good class.

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

    Thank you😊

  • @md.minhazulhaqacma3265
    @md.minhazulhaqacma3265 4 года назад

    Nice presentation and good English fluency.

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

    All ur videos are very usefull congrats. =IF($A2=TODAY(),"P","A") when am using this am getting wrong instead of present am getting abscent

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

    Well Explained

  • @adwaibowlekar3943
    @adwaibowlekar3943 5 лет назад

    Nice video very helpful sir

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

    Hiii
    I Calculate one cell value and I want to that value should match the adjacent and greater value which I have already available.
    The selected/suggested value may be is other Cell.