Why You Should Use Excel IFS Function - Don't Use Nested IF

Поделиться
HTML-код
  • Опубликовано: 21 сен 2024
  • Why You Should Use Excel IFS Function - Don't Use Nested IF
    Excel IFS Formula is Alternatives to nested IF which is new function and still available in office 365 and excel 2019 in Excel. This IFS Formula is batter and easier than nested ifs - Hindi
    #IFSfunction #iffunction #deepakeduworld
    Complete PowerPoint Tutorial : • MS Power Point Tutoria...
    Download Training File : bit.ly/315lEcA
    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 Deepak EduWorld ► / deepakeduworld
    Instagram ► / deepak__nehra
    Facebook page ► / deepakeduworld
    LinkedIn ► / deepakedu. .
    Facebook Group ► / cse92
    We Always Provide Useful & Helpful Content On The Deepak Eduworld RUclips Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
    Thanks For Watching #deepakeduworld
    Tags : deepak eduworld excel,deepak eduworld,excel,nested if,microsoft excel,if,ifs,if function excel,ifs function in excel,ifs function,ifs formula,excel formulas,nested ifs in excel,ifs formula in excel,excel online course,excel if formula,excel if function,function,formula,formulas,new excel formula 2019,excel ifs formula,excel formulas and functions

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

  • @15decdeepak
    @15decdeepak 3 года назад +12

    सर आप ग्रेट हो कमाल हो बेमिसाल हो एक नंबर और आपकी वीडियो देखकर मुझे इतना मोटिवेशन मिला इतनी इंफॉर्मेशन मिली है कि मैं अपने ऑफिस में स्मार्ट एक्सेल वर्कर बन गया हूं उसका पूरा क्रेडिट में आपको देता हूं बहुत ही शानदार वीडियो बनाते हैं सर ऐसे ही बनाते रहें और आपकी उम्र लंबी हो हम हमेशा आपको ऐसे ही देखते रहे

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

      😊😊😊😊😊😍😍😍

    • @15decdeepak
      @15decdeepak 3 года назад +3

      सर आपका कांटेक्ट नंबर मिल सकता है आपसे एक बार बात करनी थी सर मुझे मैं आपका बहुत बड़ा फैन हूं सर बहुत ही ज्यादा बढ़ा मैं आपके हर वीडियो को देखता हूं डाउनलोड करके अपने मोबाइल में रखता हूं मुझे बहुत मोटिवेशन

    • @15decdeepak
      @15decdeepak 3 года назад +1

      @@DeepakEduWorld कोई दिक्कत नहीं है सर आप बस मस्त रहो ऐसे वीडियो बनाते रहो बस हम यही चाहते हैं और हम हमेशा आपको फॉलो करते रहे हैं जिससे हमारी नॉलेज बढ़ते हैं सर कुछ और किसी से फोटोशॉप वगैरा में कोई वीडियो

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

      😍 9050401316 WhatsApp

  • @navbharatazadhindfauj4617
    @navbharatazadhindfauj4617 2 года назад +7

    from last 10 days.. i watched almost 500 videos, 40 to 60 channels, and also asked almost 70 members of my ex colleagues... but you are the one who gave the solution.. thanks a lot sir.. proudly subscribed your channel

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

    Sir aapke videos dekh dekh ke me visual basic bhi seekh gaya
    Aapka bahut bahut dhanyawad 👍👍🙏🙏🙏🙏🙏🙏

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

    Very informative video sir...Sir aap jo lock kar rage ho 1500 value ko,agar vo nahi kiya to kya hoga..?Thanks

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

    Sir, in case of IFS conditions when you put the value less than equals to 50 for (31-50) then it also can choose numbers below 30 because it also less than 50.
    Please clarify 🙏🏻

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

    Thank you Sir,apke videos bahut informative and entertaining hote hain

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

    Thanks for your awesome lessons. You explain the formulas in such detailed but simple manner that it's so easy to understand in the first time itself. Don't have to watch again and again.

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

    Bohat acha samjhaya sir apne God bless you🥰🥰🥰🥰

  • @nitinsingh.2107
    @nitinsingh.2107 3 года назад +2

    Very good Deepak!
    Nested "if" ki 2nd condition ke "else" mein hi "equal" kar saktey thhey....with only 2 "if".

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

    Thank you Deepak, your videos are very helpful for me to prepare varoius reports and anaylysis for my management.

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

    ऐसे functions की videos बनाए सर

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

    Sir Microsoft excel par full tutorial banaiye basic to advance with office work. Sir you are great teacher.

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

      Bhai its ocean which cannot be covered in one video

  • @ManojGupta-nl8fj
    @ManojGupta-nl8fj 5 месяцев назад +1

    Sir, yadi IFS Formula wali kisi excel file ko Ms office 19 se niche ke version me open karenge to yah formula work karega ya nahi aur yadi nahi karega to ise kaise fix katrenge

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

    Sir you are my best teacher sir thank you so much sir

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

    Sir isme and, or function b sath me integrate kar sakte hai kya formula me?

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

    सर, आपको खुप खुप धन्यवाद जो ifs फार्मूला का उपयोग ग्रेड लिख़ने के लिए कराया ।
    सर मेरी समस्या ये है कि ये फॉर्मल सिर्फ वर्जन 365 और ms office 16 पर ही चलता है । आप same example लेकर ms office -7 , 10 or 13 पर कैसे इस्तेमाल करे बताइये। और एक बार धन्यवाद सर

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

    Sir no words with me ..but you are best 🥰🥰🥰🥰🥰🥰

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

    Sir agar greater than,less than & between ak sath hi nikalna ho to kaise karege sir

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

    Amazing formula sir ji
    Sir aapke doosre channel pr video kb aayegi

  • @PawanKumar-yf8hn
    @PawanKumar-yf8hn 2 года назад +1

    Thank you sir ji

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

    Are bhai Aapka excel ka kaunsa version hai pehle yeh batao

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

    Excellent great job love from pakistan

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

    Very nice trick... Thank you very much.

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

    Thanks sir😊😊 very good video.
    1 tally Erp pr bhi video series laiye ..

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

    Thank you DEEPAK JI! Should I send some excel problems?

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

      Yes you can share with me... I will help you

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

    you are excellent sir and all videos are very well explained.

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

    Thank you bahut badhiya

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

    In which version this formula works.

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

    thank you sir

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

    Power full video hai Sir G

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

    Bhai apki excel ki vedio acchi lagti h....masterpiece

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

    Sir mere excell me IFS maujud nehi hai uski jagah par sirf IF hai.to is IF ko main IFS ki tarah kaise use karunga toda bata dijiye.

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

    Thankyou so much for this VIDEO, this is so HELPFUL❤❤❤❤😎😎😎😎👏👏👏👏🙏🙏🙏🙏🧐🧐🧐🧐

  • @AA.GAMING77646
    @AA.GAMING77646 Год назад +1

    Thanks

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

    E MAIL ID MILE SIR, MUJE EK FORMULA FIT KARNA HE INSURANE CALCULATIN KA TO ME AAPKO BHEJ SAKU

  • @YogesHMehta-wi2ly
    @YogesHMehta-wi2ly Год назад

    हेलो दीपक जी,
    मुझे एक डाटा में केमिस्ट्री की माप लिखनी है, यह 0.38 से 0.45 के बीच होनी चाहिए, अगर इससे नीचे आती है तो सेल हाईलाइट हो जाए और ज्यादा हो तो हाईलाइट होनी चाहिए, तो कौन सा फॉर्मूला लागू होना चाहिए?

  • @AnkitKumar-io3dv
    @AnkitKumar-io3dv Год назад +1

    What should be come for data entry work in ms excel

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

    Wow thanks you Deepak Sir ❤️

  • @Mohammadi09350
    @Mohammadi09350 9 месяцев назад +1

    Dear Respected sir May Allah Give you long life and May Allah Accept you in islam love you sir

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

    Sir, Your videos are very easy to understand. I have watched many videos online, of how to convert excel data to notepad, but I was not able to understand completely. Please try and make a video on how to convert excel data into xml format in your own words,

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

    Hallo sir
    Aap if formula ma higher, lower and sir Equal ke jaga par 1500 lana hoto sir
    = Amoun lani hoto sir
    Kese laye sir

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

    Hi, I have a query in this formula.
    I have below details. I need the answer in 1 cell only. I am able to put formulas separately.
    I want to identify the Capital gains whether STCG, STCL, LTCG or LTCL in 1 formula 1 cell
    Purchase Date 05-01-2010 07-10-2010 11-04-2023 22-05-2023
    Sell Date 12-06-2023 12-06-2023 12-10-2023 12-02-2024
    Period (Year) 13.4 12.7 0.5 0.7
    Gain/Loss -4327 6100 -1000 5000
    Capital Gain LTCL LTCG STCL STCG
    Formula for LTCL/LTCG : IF(AND((F5-E5)/365>1,J5

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

    Amazing sir ji thanks continue

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

    Sir please tell me how to download your all videos🙏🙏🙏🙏🙏🙏

  • @SayanDas-jz1jh
    @SayanDas-jz1jh 2 года назад +1

    Bohat a66ha process ha

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

    I need one solution regarding to Excel data suppose there is big data and some names is same like Ram,Ram and Ram but position is different so my question is if I type Ram should be come each Position please give me any idea or formula

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

    nice...

  • @Rohit-0964
    @Rohit-0964 2 года назад +1

    Bro ek logic es par bnaao : =if(Average......) Aisa kuch kar key dekhao ))

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

    Thank you teacher

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

    Can i embade custom fonts in excel in newer version?

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

    Wow Video

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

    Thank you Sir.

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

    सर अगर इंच को फिट में कन्वर्ट करना है और 1 इंच, 2 इंच, 3 इंच, तीनों को 0.25 फिट लिखना हो तो कैसे फार्मूला लगाएंगे इसी तरह आगे भी 13 इंच 14 इंच 15 इंच को 1.25 फिट लिखना है 16 इंच 17 इंच 18 इंच को 1.5 फीट लिखना है तो इसके लिए कौन सा फार्मूला हम एक्सेल में यूज करेंगे या क्या लॉजिक लगाएंगे

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

    Please make a tutorial with power query in excel, thanks for your nice tutorial.

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

    Love ..... Love ..... Love................... 100% Love You Dada.

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

    I need Salary calculation, conditions 260 hours worked add + 10 hours, and 280 hours worked+ 15 hours, 300 hours worked add 20 hours.
    If can use which fuction

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

    Very good Dipak sir

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

    Amazing Deepak Ji....

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

    Sir please help me. i entered this formula in excel, this formula cannot be entered because it is used more than 64 levels of nesting=IF(R11>4,"INVALID VALUE",IF(R11=4,"100%",IF(R11>=3.99,"99.72%",IF(R11>=3.98,"99.26%",IF(R11>=3.97,"98.8%",IF(R11>=3.96,"98.34%",IF(R11>=3.95,"97.88%",IF(R11>=3.94,"97.42%",IF(R11>=3.93,"96.96%",IF(R11>=3.92,"96.50%",IF(R11>=3.91,"96.04%",IF(R11>=3.9,"95.58%",IF(R11>=3.89,"95.12%",IF(R11>=3.88,"94.66%",IF(R11>=3.87,"94.2%",IF(R11>=3.86,"93.74%",IF(R11>=3.85,"93.28%",IF(R11>=3.84,"92.82%",IF(R11>=3.83,"92.36%",IF(R11>=3.82,"91.9%",IF(R11>=3.81,"91.44%",IF(R11>=3.8,"90.98%",IF(R11>=3.79,"90.52%",IF(R11>=3.78,"90.06%",IF(R11>=3.77,"89.6%",IF(R11>=3.76,"89.14%",IF(R11>=3.75,"88.68%",IF(R11>=3.74,"88.22%",IF(R11>=3.73,"87.76%",IF(R11>=3.72,"87.3%",IF(R11>=3.71,"86.84%",IF(R11>=3.7,"86.38% ",IF(R11>=3.69,"85.92%",IF(R11>=3.68,"85.46%",IF(R11>=3.67,"85%",IF(R11>=3.66,"84%",IF(R11>=3.65,"83.72%",IF(R11>=3.64,"83.6%",IF(R11>=3.63,"83.48%",IF(R11>=3.62,"83.36%",IF(R11>=3.61,"83.24%",IF(R11>=3.6,"83.12%",IF(R11>=3.59,"83%",IF(R11>=3.58,"82.88%",IF(R11>=3.57,"82.76%",IF(R11>=3.56,"82.64%",IF(R11>=3.55,"82.52%",IF(R11>=3.54,"82.4%",IF(R11>=3.53,"82.28%",IF(R11>=3.52,"82.16%",IF(R11>=3.51,"82.04%",IF(R11>=3.5,"81.92%",IF(R11>=3.49,"81.8%",IF(R11>=3.48,"81.68%",IF(R11>=3.47,"81.56%",IF(R11>=3.46,"81.44%",IF(R11>=3.45,"81.32%",IF(R11>=3.44,"81.2%",IF(R11>=3.43,"81.08%",IF(R11>=3.42,"80.96%",IF(R11>=3.41,"80.84%",IF(R11>=3.4,"80.72%",IF(R11>=3.39,"80.6%",IF(R11>=3.38,"80.48%",IF(R11>=3.37,"80.36%")))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

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

    Sir, Housing society Maintenance Sheet banaye.

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

    Thank you sir!!

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

    Dear sir I have office 365 But IFS function not showing how to install IFS function Please help !

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

    DEEPAK BRO MERA LAPTOP ME CELL LOCK NAHE HOTA HE IS KA KIA KARO

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

    Thanks for the help 👍

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

    Why to use three conditions in this if the second condition is false then equal can be fixed why to open third condition for equal?

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

    Very helpful thnx...Dear

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

    Want to take help for many conditions

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

    Wah Wah Kya bat hai

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

    Gaurav ji countif ka formula colour criteria k liye kaise use kare ,means mujhe wo count karne hai cells jo green colour k hai to kaise karun?

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

    Thanks sir ☺️☺️

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

    Pls make full tutorial on VBA...

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

    Very nice 👌

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

    Microsoft excel
    Agar hamare pas kam krne wala person left ho jaye to uski attendance ko kese manage kre mtlb uska data bhi rkhna hai or usme aage data fill bhi nhi hona chahiye .
    Or dusra ye ki attendance me half day ko kese maintain kre plz its a humble request
    Diesel meter average diesel consumption pr k.m aisi koi vdo related

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

    Nice explain

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

    Sir can u share nested if , if or condition videos

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

    Very usefull video sir

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

    Please do complex transactions. This is very simple. Use multiple ifs in one cell with multiple conditions

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

    Sir, i have a query and want to discuss about it

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

    Sir grade wale first condition me equal kyu nahi laga

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

    Shukriya

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

    Very good

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

    Please help sir
    Aapka 1 video tha... Stock inventory management ka
    Usme Apple ke badle Apple juice sale karna ho to kya formula lagega

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

    Great Job, Thank you 👍

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

    Next dynamic dashboard design sir...

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

    No other video like this video great sir

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

    sir ek hi cell me kuch dropdown list se aur kuch text manually likhnaa ho te kaise kare? Plz!

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

    Sir Sara formula samjh jata hu but IF formula nay samjhe pa raha hu q pata nay

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

    Superb sir 👌 you rocks

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

    Sir real time data record karke chart par kaise plot karte h please bataye

  • @HemantPatel-xn9rn
    @HemantPatel-xn9rn 3 года назад +2

    2019 me formula lagane k bad vahi formula 2007 me kam karegi kya??

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

      Formula's pe depend karta hai... Ki wo 2007 me available hai ya ni... Agar ni hoga to support ni karega

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

    Excellent

  • @Its.my.pleasure
    @Its.my.pleasure 3 года назад

    Office 2007 me ifs use karane ka jugad batao

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

    I want to make supermarket bill using Excell so help me

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

    very useful

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

    Thankq sir 😍

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

    Nicely explained, thanks!!!

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

    Sir , agar ham monthly fee pay karenge aur member banyega tu kya benefit rahega

  • @57satishkumarsharma
    @57satishkumarsharma 3 года назад

    good teaching ,thanks

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

    @.5:20 barbar c7 likhna par rahe he uska bhi shortcut hona chaiye

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

    =IF(M18>100,TODAY())
    THE ABOVE FORMULA IS WORKING. AND IT AUTOMATICALLY ENTERS THE CURRENT DATE.
    BUT THE PROBLEM IS ... THE DATE AUTOMATICALLY CHANGES WHEN I OPEN THIS FILE ON ANOTHER DAY.
    HOW CAN I FIX THE DATE??PLEASE