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

[@15decdeepak]

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

[@DeepakEduWorld]

😊😊😊😊😊😍😍😍

[@15decdeepak]

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

[@15decdeepak]

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

[@DeepakEduWorld]

😍 9050401316 WhatsApp

[@navbharatazadhindfauj4617]

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

[@subhashchander9470]

Sir-I am you FAN , aap great ho , aapke videos aur samjhaane ka style ekdum mast hai doubts clear ho jaate hain

[@nishakadyankadyan7698]

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

[@anikchowdhury9708]

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

[@sayeedsarwar1329]

Thank!! you Deepak always you are uploading practice files.

[@binaykumarnayak9114]

Very nice trick... Thank you very much.

[@sazalsarkar2130]

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

[@GkDilaawar]

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

[@arunkumarsinghark3024]

Amazing sir ji thanks continue

[@vikashmourya8964]

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

[@sibasankarsahoo822]

Very good Dipak sir

[@shantilalrajput8708]

Thank you sir

[@pravindevde05]

Thank you bahut badhiya

[@Saeed_Akhtar.]

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

[@abhishekdsl]

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.

[@DeepakEduWorld]

😊😊😊

[@apeduworld7004]

Nice explain

[@dakshkumar873]

Thank you Sir.

[@surendraverma5599]

Very helpful thnx...Dear

[@lavah5968]

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

[@computerscience9172]

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

[@dadabhaujadhav3865]

Thanx brother

[@vimalsoni185]

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

[@sanjaykamdar7054]

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

[@prabhakarpawar573]

Very usefull video sir

[@hajiserajuddin2870]

Thank you teacher

[@SayanDas-jz1jh]

Bohat a66ha process ha

[@taizoondean689]

Thanks for the help 👍

[@bhagyeshsakpal898]

Thankq sir 😍

[@excelclassesmobileexcel893]

very useful

[@computerknowledge6986]

Power full video hai Sir G

[@khajamohiuddin3649]

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

[@bhagwatidave1154]

Great Job, Thank you 👍

[@chyarmennanda]

Wow thanks you Deepak Sir ❤️

[@kaushal7]

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

[@idpatel8701]

Excellent

[@babar6027]

Excellent great job love from pakistan

[@pradeepsharma1389]

Superb sir 👌 you rocks

[@surajgaur]

Amazing Deepak Ji....

[@aartigupta4189]

Thanks sir ☺️☺️

[@rheapeter9709]

Thank you sir!!

[@daftarikaam8604]

Very good

[@umeshbarde5935]

nice...

[@prabhavatiranamale9490]

No other video like this video great sir

[@Yatish1307]

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

[@udaydas8818]

Very nice. Thank you

[@narendrakomu]

Very nice 👌

[@visheshgiri1354]

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

[@ManojGupta-nl8fj]

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

[@pabitraparida3321]

Appreciate sir

[@57satishkumarsharma]

good teaching ,thanks

[@bikashpathak3229]

Very helpful video 🥰

[@Abhijitjitu]

Can i embade custom fonts in excel in newer version?

[@savitabirje4953]

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

[@AnkitKumar-io3dv]

What should be come for data entry work in ms excel

[@zakaaronsafiul425]

Are bhai Aapka excel ka kaunsa version hai pehle yeh batao

[@pankajdeorukhar5655]

Awesome....

[@ashvinpatel06]

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

[@nitinsingh.2107]

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

[@DeepakEduWorld]

Yes... 👍

[@svsonu1]

In which version this formula works.

[@proficientclasses6757]

Wow Video

[@harshdas7009]

Thanks

[@pappusinghpappusingh590]

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

[@TheJagpalsingh]

Bhai its ocean which cannot be covered in one video

[@onkarshinde4424]

Ifs formula explanation 05:11

[@prudentinvestor986]

Nicely explained, thanks!!!

[@arunkumarsinghark3024]

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

[@narayannayak7242]

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

[@DataLearninghub]

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

[@jatinsawant9477]

Shukriya

[@tomar6099]

Pls make full tutorial on VBA...

[@anirbanrana9660]

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 🙏🏻

[@ZiauddinMohammadi-09350]

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

[@bhaveshparmar431]

Wah Wah Kya bat hai

[@computerscience9172]

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

[@nm_arts5868]

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?

[@DataLearninghub]

Ye vba ke through possible hai

[@arghyasarkar30]

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.

[@pandurangkilledar3254]

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

[@yourchannel6024]

Great

[@JINDER7]

Sir hamre pass bhout jadya data hai IN coding like th33000 to...., bg6600 to..., sf290000 to....., kg69000 to....., AF78000 TO.... . I WANT TO ASK THAT WHEN I WRITE IN EXCEL (LIST). AUTOMATICALLY IN ANOTHER COLOUM WRITE DATA LIKE TH33=1, BG66=2, SF29=3, KG69=4 AND AF38=5 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏 HELP ME SIR

[@DeepakEduWorld]

I ll publish video ASAP

[@JINDER7]

@@DeepakEduWorld thank you very much sir

[@shahinur70]

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

[@nileshvyas3819]

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

[@THERAVITECHNICAL]

Sir ye excel ka kaun sa virsion h

[@azmaarza7403]

Sir can u share nested if , if or condition videos

[@KhalidAfridi5158]

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

[@jahirrain4837]

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

[@rajeshshah6758]

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,

[@DeepakEduWorld]

ASAP 😊

[@muslimvideo2433]

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

[@mero4goal435]

Next dynamic dashboard design sir...

[@prashantapodar4362]

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

[@DeepakEduWorld]

I ll publish video ASAP 😊

[@mahanteshpatil7606]

Sir, Housing society Maintenance Sheet banaye.

[@dildars1]

Hi....Sir I am preparing CV database. I have different cities in one column and same state in another column. I want to use IF formula and if I write a city name in one column, it shows same state name in another column. Please suggest......

[@dildars1]

Sir....can you please share your cell number...

[@ACHARYARAMESHSACHDEVA]

Want to take help for many conditions

[@chandrashekharnavlekar7763]

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

[@shubhambansal1551]

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

[@Rohit-0964]

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

[@zabihullah3896]

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%")))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

[@kishorparmar5310]

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

[@nitinkammar5434]

Add mixi in the formula

[@rajkumarvermajrkgto1231]

Acha tha

[@kiransaraf1943]

Hi deepak sir, sir need to know how we fix secound time coming automaticlly on excel sheet ,bcs i am making onr sheet for production plan production time i have start time i have but i need when we put our production quantity..thus finish time time will ciming automatically...plz help me

[@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?

[@gsincubatormaharashtra3967]

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