Excel IF Formula - IF Function का ये Magic आपको खुश कर देगा | IF Formula in Excel in Hindi

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • Excel में ऐसा IF Formula RUclips पे नहीं सीखा होगा. become expert in excel. this if formula will now return any number or text. this if function will return character / symbols using ASCII code through char formula. here we have to use char formula inside the if formula as parameters.
    #Excel
    #Exceltips
    #ExcelTutorial
    OTHER VIDEOS:
    IF Logical Function in excel in Hindi
    • IF Logical Function in...
    IF AND Logical function in excel in Hindi
    • IF AND Logical functio...
    SUMIF formula in excel | Hindi || Excel sumif formula examples in hindi
    • SUMIF formula in excel...
    Sumifs Formula
    • SUMIFS Formula in Exce...
    countif formula in excel in hindi
    • COUNTIF formula in exc...
    How To Use Countifs Formula in Excel in Hindi | Best Ever Explanation
    • How To Use Countifs Fo...
    How to use IFERROR formula in excel || HINDI
    • How to use IFERROR for...
    if You are computer user, excel user, ms word user, power point user, sql user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel deepak eduworld and subscribe.
    ___________________________________________________
    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    𝗣𝗹𝗲𝗮𝘀𝗲 𝗦𝘂𝗽𝗽𝗼𝗿𝘁 𝗠𝗲 𝗙𝗿𝗶𝗲𝗻𝗱𝘀 & 𝗦𝗵𝗼𝘄 𝗬𝗼𝘂𝗿 𝗟𝗼𝘃𝗲 𝗕𝘆 𝗟𝗶𝗸𝗲 𝗦𝗵𝗮𝗿𝗲 & 𝗖𝗼𝗺𝗺𝗲𝗻𝘁𝘀
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)
    ___________________________________________________
    Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
    Deepak EduWorld Playlist's:
    ADVANCED EXCEL ► goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
    Excel Tips & Tricks ► goo.gl/wAj1jh
    MS WORD ► goo.gl/B4TeSA
    HTML5 & CSS3 ► goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ► goo.gl/paZmpn
    Automatic Invoice's in excel ► goo.gl/dFhg54
    Subscribe to Deepak EduWorld ► / deepakeduworld
    Follow on Instagram ► / deepak__nehra
    Like my Facebook page ► / deepakeduworld
    Follow on LinkedIn ► / deepakedu. .
    Facebook Group ► / cse92
    Tags:
    advence excel course,, advanced excel tutorial in hindi, deepak eduworld, deepak nehra, excel tips, excel user, computer user, technology, computer tips

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

  • @ShivamKatheriya-yz6wf
    @ShivamKatheriya-yz6wf 2 года назад +1

    It's very good video

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

    Good job

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

    Very New things for me

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

    Nice Formula Sir G.

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

    Very Very Nice...

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

    Thanks sir ji

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

    nice..

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

    Good morning sir

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

    Super explain

  • @thinking-Mann
    @thinking-Mann 4 года назад +1

    Wow..very nice!👍🏼👍🏼

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

    New formula hai. Mazaa aa gaya.

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

    BOHAT NICE SIR

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

    Very good sir

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

    Sir ye vedio kafi interesting tha

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

    Nice 👍👍

  • @MuhammadIbrahim-xb1tr
    @MuhammadIbrahim-xb1tr 4 года назад +2

    Sir first of All Salam to you and good wishes from pakistan and sir thanks for the sharing of your knowledge with us thank you sir

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

    Super Sir

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

    You explain it very well and special thanks for special tips 👍👍🙏

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

    Jaisa title waise kaam Hart off sir really unique video

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

    very good and very informative

  • @user-tw9if4rt2x
    @user-tw9if4rt2x 5 лет назад

    Very good and adoptable.

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

    Nice

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

      Sir if I want to enter "NILL" in a cell if the reference cell contain "Sunday" otherwise any number, how can I write the formula with if condition...if you don't bother please reply..

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

    Super sir we are feeling relex

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

    Sir how to total checkmark sign in colume please suggest formula..

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

    Bahut badiya sirji

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

    Bht acha lga...

  • @AmitPal-ek9mw
    @AmitPal-ek9mw 5 лет назад

    Thank you sir bahut acha gyan diye aap

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

    🙏🙏🙏 make mark sheet in pass, fail and promote other supliment

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

    Owsmm bhai

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

    Wahh great

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

    Good trick

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

    Very nice video sirji

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

    Solved my big problem, Thank you

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

    Wow amazing !

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

    Kya baat hai Sir

  • @s.hazratkazimi9891
    @s.hazratkazimi9891 5 лет назад +1

    Zabrdast Deepak Sir

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

    Deepak
    New concept. Thanks.

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

    Superb...please upload video on vlookup where data has text and number both

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

    You rock man...great work.

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

    Superb video ji.. Do a live session sir.. I ve to c u live.. U r amazing.. Keep up d good work..

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

    Nice sir g

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

    Very nice bro 🙏🙏👌👌👍

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

    Deepak Bhai very nice video.

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

    Very useful nice formulas

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

    Aise Naya Naya vedio banate rahiye

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

    Sir very nice video

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

    NEW THING SIR, VERY NICE
    OM SAI RAM

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

      Please please visit www.RUclips.com/c4ccoachingforcareers. For advanced Excel videos

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

    Thanks Deepak

  • @MithleshKumar-qf3hk
    @MithleshKumar-qf3hk 5 лет назад

    Sir ji Bahut achcha vedeo raha

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

    Grace Mark sheet make send

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

    Nice video sir

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

    Osm sir

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

    Sir, i need one help
    If i enter anything in one cell than how the full row can i get in another sheet

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

    Sir is topic co update kero na :-
    Question : mere pass 20 other countries ki party ya he or sub party me different document ki list ke hisabse lagti he..........
    Muje list generate karvani he...... Jese ki ex : " surya,USA " , jab me dropdown me selecte karu to
    To usko lagti list samne aani chahiye or dusri list ke font condition through white font me change kervani he........
    Please make this video .......
    And best wishes in your heart.......

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

    Vah, very interesting👌
    Happy New Year sirji

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

    Affice me us hone Wala video banayo sir

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

    Nice video

  • @AhmadKhan-mg3lc
    @AhmadKhan-mg3lc 5 лет назад +1

    Aslam O Aalikom G kase hy ap muje
    Sir ye bate ke excal sheet ka backup kase lange ?
    &
    Salary sheet ko copy karne ke bad formula kase ate hy me ne ik salary sheet banye hy but os ko copy karnr ke bad formula un active hojate hy?
    Reply must

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

    sir aik institute managment key barey me bhi video bana dejey shukriya

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

    3 column m students k subject code wise filter & copy and count

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

    Dear Sir .
    my laptp excel i think wrong button type so in excel numerical no wrong found its 1 replace 0 so plz tell me solution

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

    How to use dsum in coloum or row

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

    Excellent Sir, nice of u, pls keep it up, I'm requesting to teach us which I have requested below , thnx

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

      Ok g.. Please wait i ll publish video shortly

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

    Very nice video

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

    Tally related b post kijiye

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

    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

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

    ok it nice work

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

      Please please visit www.RUclips.com/c4ccoachingforcareers. For advanced Excel videos

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

    I inspired from the video

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

    sir ek is per video banayiye ki jinka aaj birthday h bs wo show kre

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

    very nice

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

    Kya . Good or exe me....first exe chahiye to....kya kare ...pse help

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

    Sir, agar hour or minute me ho e.g 04:08:00 or mjhe chahye 4 hr se jyada aaye to No or kam me yes.
    Please ispe ek video ya suggest kijye

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

    दीपक भाई यदि बॉस पागल हो जाएगा तो पगार कोन देगा?😀

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

    Mere pas 3 coloum hai qty, purchase rate, sale rate , profit me konsa formula use hoga

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

    Please reply me
    Excel me 17 digit enter karne par last digit automatically zero me convert ho jata hai
    Data bhi bahut enter kar diya kya vah ab correct ho sakta hai jo maine enter kiya hai

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

      Just select the whole column.. Go to home tab.. From number block.. Click on general.. And change format to text

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

    Sir telly ke videos bana do please 💜👍💙❤💝💞👏💛💚💖💟💓👌💕

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

    Sir, blank cell ke samne bhi tick mark aa raha hai, kya karu??cell blank hoga to tick mark nahi aye iske liye kounsa formula use karna padega? plz reply.

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

    Sir, I'm looking for double scanning with color code, I have searched in yr lesson but unfortunately i couldn't find it, would u pls teach us how the other are working on it...... thnkx

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

    Sir l applied if formula ad
    =If(lo.value,testvalue,"y","n") entry got
    ##### pl guid me

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

    1. सर मुझे 7.75 से जादा है तो Distinction आना चाई
    2. 7.75 to 6.75 है तो higher distinction आना चाहिये
    3. 6.75 to 6.25 हे तो first class चाई
    4. 6.25 to 5.5 हे तो second class चाहिये
    5. 5.5 के नीचे है तो pass class
    6. Fail

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

    Agr char hi lena hai to shi hai nhi to words me problem aati hai

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

    Sir ledger bnana bhe sekha d

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

      G.. Please wait.. I have received your comment from long time.. Please wait a little.. I ll publish it shortly

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

    Sir if formula work nahi kar raha hai keya karu

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

    whats ap per reply toh krte nhi mene kuch puchna tha

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

    ¿Cómo terminé aqui?

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

    SHEET KA NAME HINDI M KAISE LIKH SKKTE H ?

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

    Sir if formula me colour code kyse use kre

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

    Mera sawala hi mujhe excel k data se subject grup list banani hi

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

    Sir 1 mera question hai solve kr do

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

    Please video bano

  • @sunilsharma-ll8wo
    @sunilsharma-ll8wo 5 лет назад +1

    Deepak g, mere excel me character me font nhi shows karta hau

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

    =IF((C10+D10)>E10,E10,(F10+G10)) yeh formula kya batata hai plz help

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

    98***********23 is type ke number ko excel lete he lekin pura number show Karna chahiye star nhi

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

      @Gopal Chaudhary - Excel Trainer
      98***********23 is type ke number ko excel lete he lekin pura number show Karna chahiye star nhi

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

    Php sir sekhy

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

    Sir apse mene question Kiya tha answer nhi diya aapne

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

    Folder marker ki key dedi jiy plz sir

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

      @Gopal Chaudhary - Excel Trainer
      Folder marker ki key

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

    Sir rupees ka code kaya hai

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

    दीपक जी excel का data किसी पोर्टल पर online entry के लिए कैसे set करे
    ताकि offline data एक बार मे ऑनलाइन form में feed हो जाये

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

    Sir c4c wala chanal kis subject ke liye he you tub 👍👍👌💟💚💗💛💜💓💕💞💝❤💙

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

    How to contact you