Why You Should Use Excel IFS Function - Don't Use Nested IF
HTML-код
- Опубликовано: 29 сен 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
सर आप ग्रेट हो कमाल हो बेमिसाल हो एक नंबर और आपकी वीडियो देखकर मुझे इतना मोटिवेशन मिला इतनी इंफॉर्मेशन मिली है कि मैं अपने ऑफिस में स्मार्ट एक्सेल वर्कर बन गया हूं उसका पूरा क्रेडिट में आपको देता हूं बहुत ही शानदार वीडियो बनाते हैं सर ऐसे ही बनाते रहें और आपकी उम्र लंबी हो हम हमेशा आपको ऐसे ही देखते रहे
😊😊😊😊😊😍😍😍
सर आपका कांटेक्ट नंबर मिल सकता है आपसे एक बार बात करनी थी सर मुझे मैं आपका बहुत बड़ा फैन हूं सर बहुत ही ज्यादा बढ़ा मैं आपके हर वीडियो को देखता हूं डाउनलोड करके अपने मोबाइल में रखता हूं मुझे बहुत मोटिवेशन
@@DeepakEduWorld कोई दिक्कत नहीं है सर आप बस मस्त रहो ऐसे वीडियो बनाते रहो बस हम यही चाहते हैं और हम हमेशा आपको फॉलो करते रहे हैं जिससे हमारी नॉलेज बढ़ते हैं सर कुछ और किसी से फोटोशॉप वगैरा में कोई वीडियो
😍 9050401316 WhatsApp
Thanks for the help 👍
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
Very nice. Thank you
Sir help chahiye aapki
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
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.
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
I ll publish video ASAP
@@DeepakEduWorld thank you very much sir
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
ऐसे functions की videos बनाए सर
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 Sara formula samjh jata hu but IF formula nay samjhe pa raha hu q pata nay
Are bhai Aapka excel ka kaunsa version hai pehle yeh batao
सर, पंद्रह बीस लोगों का data same format पर मिला है, उन सबको copy paste करके एक master sheet बनाना होता है, उसके बाद MIS Report तैयार करनी होती है, और उसमे Pivot table की सहायता से Report summary भी बनाना पड़ता है, Competency Tracer भी बनाकर सबकी Performance level check करना पड़ता है, please ऐसे report बनाना सीखा दीजिए, please please please sir, मेरे पास बहुत सी Excel queries है, please हम आपसे direct कैसे अपने प्रश्न पूछ सकते हैं please guide करें l 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l please contact mode बता दे l Gmail, Whatsapp, phone number, please please please 🙏🙏🙏Help me sir
Sir agar greater than,less than & between ak sath hi nikalna ho to kaise karege sir
Bhai stock pe bana o na plss
DEEPAK BRO MERA LAPTOP ME CELL LOCK NAHE HOTA HE IS KA KIA KARO
Want to take help for many conditions
ifs function is not present in my excel
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
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%")))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Why my excel 2016 not showing Ifs and Switch function
Still available in office 2019
@@DeepakEduWorld But,
In my organization excel 2016 is available,
Can you please, share some add ins link, or any other way, so that i able to use ifs and Switch function in 2016.
Regards
Dear Respected sir May Allah Give you long life and May Allah Accept you in islam love you sir
Dear sir I have office 365 But IFS function not showing how to install IFS function Please help !
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 🙏🏻
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
=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
Bro ek logic es par bnaao : =if(Average......) Aisa kuch kar key dekhao ))
Can you please help me to
2019 me formula lagane k bad vahi formula 2007 me kam karegi kya??
Formula's pe depend karta hai... Ki wo 2007 me available hai ya ni... Agar ni hoga to support ni karega
Sir ms office 2019 download link dega kia
हेलो दीपक जी,
मुझे एक डाटा में केमिस्ट्री की माप लिखनी है, यह 0.38 से 0.45 के बीच होनी चाहिए, अगर इससे नीचे आती है तो सेल हाईलाइट हो जाए और ज्यादा हो तो हाईलाइट होनी चाहिए, तो कौन सा फॉर्मूला लागू होना चाहिए?
Please make a tutorial with power query in excel, thanks for your nice tutorial.
सर अगर इंच को फिट में कन्वर्ट करना है और 1 इंच, 2 इंच, 3 इंच, तीनों को 0.25 फिट लिखना हो तो कैसे फार्मूला लगाएंगे इसी तरह आगे भी 13 इंच 14 इंच 15 इंच को 1.25 फिट लिखना है 16 इंच 17 इंच 18 इंच को 1.5 फीट लिखना है तो इसके लिए कौन सा फार्मूला हम एक्सेल में यूज करेंगे या क्या लॉजिक लगाएंगे
Amazing formula sir ji
Sir aapke doosre channel pr video kb aayegi
Very informative video sir...Sir aap jo lock kar rage ho 1500 value ko,agar vo nahi kiya to kya hoga..?Thanks
Thank you sir ji
What should be come for data entry work in ms excel
Very good Deepak!
Nested "if" ki 2nd condition ke "else" mein hi "equal" kar saktey thhey....with only 2 "if".
Yes... 👍
Thank you sir
सर, मेरे सिस्टम में 320 gb की हार्ड डिस्क लगी थी वो खराब हो चुकी है अब मुझे 500 gb की हार्ड डिस्क लगाना है जो कि मुझे मदरबोर्ड पर हार्ड डिस्क इंस्टॉल करते नही आ रही है , तो सर उसे मदरबोर्ड पर इंस्टॉल कैसे करें । प्लीज सर, मेरे लिए एक विडियो बना सकते हो क्या ?
ASAP 😊
thank you sir
Sir please tell me how to download your all videos🙏🙏🙏🙏🙏🙏
Lock kyu krte है
Thanks sir😊😊 very good video.
1 tally Erp pr bhi video series laiye ..
Thanx brother
I am krushna rathod computer operator that set. Match 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
Sir aapke videos dekh dekh ke me visual basic bhi seekh gaya
Aapka bahut bahut dhanyawad 👍👍🙏🙏🙏🙏🙏🙏
Can i embade custom fonts in excel in newer version?
Thanks sir
Why are you escaping the use of "else" part with multiple "if"s ???
Bohat acha samjhaya sir apne God bless you🥰🥰🥰🥰
Wow Video
Thanks
Sir isme and, or function b sath me integrate kar sakte hai kya formula me?
Thanks
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?
Excellent great job love from pakistan
nice...
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.
😊😊😊
I want to make supermarket bill using Excell so help me
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...
Vlookup with multiple conditions ka bta dy
Love from Pakistan 🇵🇰
You can try this tutorial...
ruclips.net/video/6uvK3unXnxQ/видео.html
Thank you Sir,apke videos bahut informative and entertaining hote hain
If ke sath And lagane se b ho jayega
👍
Sir, Housing society Maintenance Sheet banaye.
Sir grade wale first condition me equal kyu nahi laga
Thank you sir
Sir no words with me ..but you are best 🥰🥰🥰🥰🥰🥰
Sir, i have a query and want to discuss about it
❤
Amazing sir ji thanks continue
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
Ifs formula explanation 05:11
Office 2007 me ifs use karane ka jugad batao
Sir you are my best teacher sir thank you so much sir
Next dynamic dashboard design sir...
Wow thanks you Deepak Sir ❤️
Thank you DEEPAK JI! Should I send some excel problems?
Yes you can share with me... I will help you
Thankyou so much for this VIDEO, this is so HELPFUL❤❤❤❤😎😎😎😎👏👏👏👏🙏🙏🙏🙏🧐🧐🧐🧐
Very nice trick... Thank you very much.
Pls make full tutorial on VBA...
@.5:20 barbar c7 likhna par rahe he uska bhi shortcut hona chaiye
you are excellent sir and all videos are very well explained.
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 can u share nested if , if or condition videos
Yahi date me bataiye stage wise please help me
If (10-08-2020 to 12-08-2020 "1st stage")
If (13-08-2020- to 15-10-2020"2 stage")
If (16.10.2020 to 20-10-2020"3rd stage)
Please help me 🙏🙏🙏🙏
@@RohitPatel-ip8wh ni ye aise work ni karega... Aap ye tutorial try kariye...
ruclips.net/video/B6NKiWZwwIs/видео.html
sir ek hi cell me kuch dropdown list se aur kuch text manually likhnaa ho te kaise kare? Plz!
I ll publish video ASAP 😊
In 2013 ifs is not supported
Very helpful thnx...Dear
Value of false ??
0
Thank you teacher
Thank you bahut badhiya
सर, आपको खुप खुप धन्यवाद जो ifs फार्मूला का उपयोग ग्रेड लिख़ने के लिए कराया ।
सर मेरी समस्या ये है कि ये फॉर्मल सिर्फ वर्जन 365 और ms office 16 पर ही चलता है । आप same example लेकर ms office -7 , 10 or 13 पर कैसे इस्तेमाल करे बताइये। और एक बार धन्यवाद सर
Sir ye excel ka kaun sa virsion h
क्या सर if का 8 से ज्यादा बार नहीं होता है क्या
Bhaiya if or ifs mai zada difference nhi hai
1st
Sir, I am using ms office 7 in my computer. and in this version ifs function is not working
Please explain how to use in ms word 7 or 10 version
Very good Dipak sir