Why You Should Use Excel IFS Function - Don't Use Nested IF
Вставка
- Опубліковано 13 жов 2020
- 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 UA-cam 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
सर आप ग्रेट हो कमाल हो बेमिसाल हो एक नंबर और आपकी वीडियो देखकर मुझे इतना मोटिवेशन मिला इतनी इंफॉर्मेशन मिली है कि मैं अपने ऑफिस में स्मार्ट एक्सेल वर्कर बन गया हूं उसका पूरा क्रेडिट में आपको देता हूं बहुत ही शानदार वीडियो बनाते हैं सर ऐसे ही बनाते रहें और आपकी उम्र लंबी हो हम हमेशा आपको ऐसे ही देखते रहे
😊😊😊😊😊😍😍😍
सर आपका कांटेक्ट नंबर मिल सकता है आपसे एक बार बात करनी थी सर मुझे मैं आपका बहुत बड़ा फैन हूं सर बहुत ही ज्यादा बढ़ा मैं आपके हर वीडियो को देखता हूं डाउनलोड करके अपने मोबाइल में रखता हूं मुझे बहुत मोटिवेशन
@@DeepakEduWorld कोई दिक्कत नहीं है सर आप बस मस्त रहो ऐसे वीडियो बनाते रहो बस हम यही चाहते हैं और हम हमेशा आपको फॉलो करते रहे हैं जिससे हमारी नॉलेज बढ़ते हैं सर कुछ और किसी से फोटोशॉप वगैरा में कोई वीडियो
😍 9050401316 WhatsApp
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
Thank you Sir,apke videos bahut informative and entertaining hote hain
Thank you Deepak, your videos are very helpful for me to prepare varoius reports and anaylysis for my management.
you are excellent sir and all videos are very well explained.
Very nice trick... Thank you very much.
Sir aapke videos dekh dekh ke me visual basic bhi seekh gaya
Aapka bahut bahut dhanyawad 👍👍🙏🙏🙏🙏🙏🙏
Nicely explained, thanks!!!
Wow thanks you Deepak Sir ❤️
Amazing Deepak Ji....
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.
😊😊😊
Thanks for the help 👍
Bohat acha samjhaya sir apne God bless you🥰🥰🥰🥰
Great Job, Thank you 👍
Sir no words with me ..but you are best 🥰🥰🥰🥰🥰🥰
Thank you bahut badhiya
good teaching ,thanks
Thank you teacher
Sir you are my best teacher sir thank you so much sir
Very helpful thnx...Dear
Thank you Sir.
Superb sir 👌 you rocks
Bhai apki excel ki vedio acchi lagti h....masterpiece
Very nice. Thank you
Amazing sir ji thanks continue
Thank you sir
Very good Dipak sir
Love ..... Love ..... Love................... 100% Love You Dada.
Excellent
Thankyou so much for this VIDEO, this is so HELPFUL❤❤❤❤😎😎😎😎👏👏👏👏🙏🙏🙏🙏🧐🧐🧐🧐
Thank you sir ji
Thank you sir!!
Awesome....
Appreciate sir
Very informative video sir...Sir aap jo lock kar rage ho 1500 value ko,agar vo nahi kiya to kya hoga..?Thanks
No other video like this video great sir
Very helpful video 🥰
Very usefull video sir
Power full video hai Sir G
Thanx brother
Thanks sir ☺️☺️
Thanks
Thankq sir 😍
Nice explain
Please make a tutorial with power query in excel, thanks for your nice tutorial.
very useful
Thanks sir😊😊 very good video.
1 tally Erp pr bhi video series laiye ..
Amazing formula sir ji
Sir aapke doosre channel pr video kb aayegi
Very nice 👌
Bohat a66ha process ha
nice...
Great
thanks
Wah Wah Kya bat hai
Very good
Shukriya
Excellent great job love from pakistan
Wow Video
Pls make full tutorial on VBA...
Please do complex transactions. This is very simple. Use multiple ifs in one cell with multiple conditions
Next dynamic dashboard design sir...
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 🙏🏻
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
Sir isme and, or function b sath me integrate kar sakte hai kya formula me?
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
Can i embade custom fonts in excel in newer version?
Very good Deepak!
Nested "if" ki 2nd condition ke "else" mein hi "equal" kar saktey thhey....with only 2 "if".
Yes... 👍
Sir can u share nested if , if or condition videos
ऐसे functions की videos बनाए सर
Acha tha
What should be come for data entry work in ms excel
👏👏
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,
ASAP 😊
Sir agar greater than,less than & between ak sath hi nikalna ho to kaise karege sir
Sir, Housing society Maintenance Sheet banaye.
Sir Microsoft excel par full tutorial banaiye basic to advance with office work. Sir you are great teacher.
Bhai its ocean which cannot be covered in one video
सर, आपको खुप खुप धन्यवाद जो ifs फार्मूला का उपयोग ग्रेड लिख़ने के लिए कराया ।
सर मेरी समस्या ये है कि ये फॉर्मल सिर्फ वर्जन 365 और ms office 16 पर ही चलता है । आप same example लेकर ms office -7 , 10 or 13 पर कैसे इस्तेमाल करे बताइये। और एक बार धन्यवाद सर
Sir please tell me how to download your all videos🙏🙏🙏🙏🙏🙏
wow
Dear Respected sir May Allah Give you long life and May Allah Accept you in islam love you sir
❤
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
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
Thank you DEEPAK JI! Should I send some excel problems?
Yes you can share with me... I will help you
In which version this formula works.
E MAIL ID MILE SIR, MUJE EK FORMULA FIT KARNA HE INSURANE CALCULATIN KA TO ME AAPKO BHEJ SAKU
Sir, i have a query and want to discuss about it
Please help sir
Aapka 1 video tha... Stock inventory management ka
Usme Apple ke badle Apple juice sale karna ho to kya formula lagega
Add mixi in the formula
Are bhai Aapka excel ka kaunsa version hai pehle yeh batao
Superman
Sir real time data record karke chart par kaise plot karte h please bataye
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?
Sir , agar ham monthly fee pay karenge aur member banyega tu kya benefit rahega
Bro ek logic es par bnaao : =if(Average......) Aisa kuch kar key dekhao ))
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%")))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
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?
Ye vba ke through possible hai
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......
Sir....can you please share your cell number...
sir ek hi cell me kuch dropdown list se aur kuch text manually likhnaa ho te kaise kare? Plz!
I ll publish video ASAP 😊
How to make Excell a app or an software
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