EXCEL IF FORMULA :Part 1 | Ms - Excel if function in hindi
Вставка
- Опубліковано 13 жов 2024
- Excel IF function
We cover a few examples including
1. Simple IF function
2. IF function with formula inside
Basic Excel Playlist Link - • Basic Excel-The Learni...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#Ifformula #msexcel #logicalfunction #excelvideo #innozant
I've literally paid close to 50k to learn all the concepts of Analytics and Excel. But trust my word, every single day I am only and only learning from your videos. The way you explain all the concepts are effective and efficient. I hope that your hardwork witnesses exponential success and your name becomes synonymous to excel aficionado.
OMG.. Really means a lot to me Nikita .God bless you..Have a wonderful career ahead
Sir ek playlist arrange krr dijiye excel ka from basic to advance in single playlist where all excel formulae video uploaded
@@Innozant Thanks to you sir for putting in so much hardwork and trust me it is evident in each and every video of yours that you give your 100%
@@nikitarai3701 Thanks Nikita. Really means a lot
I agree very well explained concept very well
love you sir, I'm pakistani but apk teaching style ko bht pasand kia h men ne.
Respect...! nothing can be explained so easily the way u explained.. Appreciate that...!
I have learnt a whole mis executive course from a reputed institution..jiska bhut nam hai but ab pta chl rha h unhone kuch nhi sikhaya bs pagl bnaya hai...sir k videos phle mil jate to mera time or money waste na hota on such a useless institute.... sir aap bhut acha kam kr rhe ho ... pls carry on..I pray for u from heart..god bless you 🙏🙏
Thanks Shivangi...Mere liye ye Hi sabse bada asset hai dear ki ye Course apke lif me value add kar pa rhe hain..Step by step seekhye jaiye jab tak meri existance hai is duniya me apko seekhate rhenge,Mere videos humesha aate rhenge..aur aapko bht kuch seekhna hai .
Step by steo seekhiye..(Video ke description me Playlist in sequence diya gya hai waise hi seekhna)🙏❤️❤️❤️❤️
Mis course Learning Process
ua-cam.com/video/2935505X3yU/v-deo.html
Sir abb kya taarif karoon aapki aap laajavaab hai excel mein kaas aap jaisa teacher mujhe pehle mile Jata toh mein excel mein expert banjata but now mujhe dheere dheere excel samaj aaraha hai aur isski importants bhi thank you sir 🙏🙏🙏
Meri yhi sbse badi khushi h ki apke life me kuch value add ho pa raha hai in videos ke madhyam se.thanks for being part of Innozant ❤️❤️
@@Innozant 🙏🙏🙏🙏 sir
सर आपकी विडियो बहुत अच्छी लगी । ऐसी विडियो तो यूट्यूब पर नही है ।
Thanks Dinesh Ji .Step by steo seekhiye Basic Excel playlist pejle finish kijiye
Usle baad advance ke video in sequence dekhna aur seekhna hai
सर आप जिस तरीके से समझाते हैं ऐसा कोई भी नहीं समझता, Love you Sir ❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️😘😘😘😘
Thanks Veeru..Keep Learning ♥️♥️
thanks a lot sir for the wonderful playlist , sir would you mind to make a playlist like this one about powerBI and DAX
I really learn lot from your video lecture
Your teaching method excellent sir.
Thanks Videsh
Good work sir app bahut acha padata ho
Thanks
मैं स्टेप बाय स्टेप ही आपके विडिओ देख रहा हूँ , फ्री में सीखने का मज़ा ही अलग है , धन्यवाद फार फ्री कोचिंग ।
👍
Hi Sir, The way you explain is awesome... Can you please share some assignment on conditional formatting and (if function) logical function.. to practice 😊
Kindly check proquest assignment series playlist
Sir, I have learned a lot from your video, if ever there is a problem, your videos will be very helpful to solve the problem
You have a small request sir, if you make a separate playlist of if function, I will be very helpful.
Thanks..dear...Basic excel ke playlist me in sequence videos rakhe hue hain..dear
Good knowledge sir
Thanks for the helpful video 🙏🙏🙏Sir
Awesome sir you are great teacher
Thank you Sirji , Once again you rock!
SIR BAHUT BADHIYA SAMAJH ME AA RHA HAI
Sir Your way is easy to understand
Thanks Anita.❤️🙏
Recommend you take start your learning journey from playlist basic Excel..❤️🙏
awesome video sir
Auto hide & unhide row mate function joie chhe
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
Zbrdst concept 👌
Please sir aap aise example or dijiye
Excellent
Sir could you please advise , am i qualified for mis executive if i have completed till kpi dashboard from the begining of your series but not aware with macro vba ?
Yes You are,Go ahead and start applying for MIS executive profile.VBA is not mandatory in every organization dear it is add on advantage
Isi me format me hamko production slabs set karna yani production ke hisab se rate ana chahiye man lijiye 1-50 hua to 120/-, 50se uper - 100ton hua to 130/- per ton, 100se uper- 130ton hua to 140/- per ton rate ana chahiye (ek hi column per rate target achieve ke hisab se rate auto fill ho jaye) aur dusra tarika ( rate ka column alag alag ho 120/- , 130/- 140/-) agar target hua to value aye aur nahi hua to 0 value aye)
thanx sir ji, आप बहुत अच्छी तरह से समझाते है
❤️ Thanks
kiya baat hai aaap ki sir love you
Thansk Sawai❤❤
Sir aap offline class bhi dete ho main ghaziabad main rhta hu
Haan offline aur online live class chalta hai aap join kar sakte hain..For .
more details kindly whatsapp on 7065069985
Thank you so much sir 🙏
Thanks Mohit Ji..Happy learning
your are great sir
Thanks Abhishek for watching and for your valuable feedback.Keep learning step by step from playlist and share with your friends to learn the same.
17:07 Sir aap drag mai copy paste kase krte ho?
drag Matlab.. may be fill down fill right Kiya hoga .ctrl d ,ctrl r
THANK YOU SIR 👍👍👍👍👍👍👍
Thanks dear
SIR, IF ke sath COUNTIF Use karke bhi pass fail result aa sakta h kya?
Please reply sir🙏
Bilkul aa sakta hai..maine Interview cracker series me bhu karaye hainaur abhi aane wale maharaj series me again aise questions milenge aapko
Baki basic excel video Playlist basic excel me jod sir.
Kya kehna chahte hain nhi aaya samajh dear..seprate playlist bana hua hai sabka dear
Samajh me aaya sir par kuch aur example kara do
Please assist how can make numbers to words
Hi Nishi..Watch my lates video convett number to words
IF & nested IF 👍👍👍
Thanks
Nice vedio sir
nice video
Good sir
Sir grade Ka MATLAB to A B C D YE SAB HOTA HAI NA RESULT MEIN HUM DECLAR KARTE HAI KI WO PASS HAI YA NHI WO BHI PER SUBJECT WISE CHECK KARTE AGAR HAR SUBJECT MEIN 33 SE ABOVE HOGA TO PASS OTHER WISE FAIL.
haan wo bhi ho sakta hai..countif se aur acha..aage ke videos me karaya hai Maine..seekhte chaliye step by step
@@Innozant yes sir mein bs Puch rha tha aap SE Jo mein Soch rha tha wo shi hai ya galat
sahi soch re h
@@Innozant thanks sir batane ke liye
Sir condition ke base per percentage kese nikale plz ans jarur dena
Kis base par percentage nikalna chahte hain Jaise ki ?
Percentage to total divided by jitne no. Of subject Hain usse decide Kar dijiye..Ydi condition percentage nikalne me bhi lagana chahte Hain to puchiye kis base par percentage calculate karna chahte Hain..ya to Ap datasheet ek Baar dikha dijiye. @innozantofficial (telegram id)
Very interesting
👍
Awesome
Sir, How to undo after evaluating a function
Ctrl z dear
i am not able to get practice file in that Google Drive. This video is under basic excel . But there is not any practice file for this or for other videos ,like cell referencing etc.
Please guide me.
Ok.You may check Basic Excel playlist folder by tomorrow,Will try to add combined example till cell reference or other topic may be not there,Will check it all and upload the same.
@@Innozant Thannnnks a looot, for kind response
Check Basic Excel Assignment Folder -Excel Intro , Cell Reference , Condition Formatting and Logical Function Assignment Practice folder uploaded.
@@Innozant I am not able to find these function , referencing ,logical functions and formating under the basic excel . Dont worry, actually i know these basic things , but i dont want to miss any video which is taught by u.There is always something new which i learn, by seeing your videos, and i have feeling that if i learnt form u will never forget in future.!
@@Innozant Oh I am soo sorry, i did not notice that tabs on top, i just started to find inside of that . Please dont mind. I got all ones which i was looking.
Thanks a lot , u are very prompt .
Sir plz if and or ya wali serious Puri baana easy hard problem baatna plzzz sir
👍🙏♥️
❤️❤️
Ap help kr do na Sr ji
Jo video dekhu us ka vhi example ya questions
Doond ke kse kru mai🤕☹️
Haan direct link bhi daal rha hu..hald active kar dunga direct video example link
Osssmmmmm
Mai SR ji Link pr click krta hu to full list aa jati hai to mai download kse kru example
Jse mujko abi ke video ka Question dekhna hai ap ki Pdf file me se to mai ksee doondu us ko
Ki mujhe abi ke video ka Question mill gye
Ap ki Pdf ke fulll file hai but download ke time pr smz nhi aata ki download kse kru clik kru kisi pr or vo milta nhi 🤕🤕
Oho..Rahul ji playlist wise eakahnhaj exmaple..
Aur seprate link par bhi main kaam kar ra hu kisi reason se link broken H gya hai
Ok sr ji
deer si
F9 karne ke bad return hona
Ctrl+z
Thanks sir
Good 🇵🇰🇵🇰
Please please please please please........... Sir
True me fail kar do sir
Hii..galat na le..apne jo % nikala wo kahi avg to nahi tha .
Galat kisliye dear , percentage hi to nikala hoga ,jitna value hai use 5 se divide means 500
Unnecessarily dragging.
So boring taking more time unnecessarily
Conceptual part is more important then implementation.Good in depth learning will take time.