Тёмный

EXCEL IF FORMULA :Part 1 | Ms - Excel if function in hindi 

Innozant
Подписаться 154 тыс.
Просмотров 61 тыс.
50% 1

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

Опубликовано:

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 108   
@nikitarai3701
@nikitarai3701 Год назад
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.
@Innozant
@Innozant Год назад
OMG.. Really means a lot to me Nikita .God bless you..Have a wonderful career ahead
@raj0936
@raj0936 Год назад
Sir ek playlist arrange krr dijiye excel ka from basic to advance in single playlist where all excel formulae video uploaded
@nikitarai3701
@nikitarai3701 Год назад
@@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%
@Innozant
@Innozant Год назад
@@nikitarai3701 Thanks Nikita. Really means a lot
@user-hq5gr9hk1j
@user-hq5gr9hk1j Год назад
I agree very well explained concept very well
@shahzadsiddiqui5117
@shahzadsiddiqui5117 Год назад
Respect...! nothing can be explained so easily the way u explained.. Appreciate that...!
@shibuclasses2701
@shibuclasses2701 3 года назад
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 🙏🙏
@Innozant
@Innozant 3 года назад
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2935505X3yU.html
@veerurajbhar1605
@veerurajbhar1605 2 года назад
सर आप जिस तरीके से समझाते हैं ऐसा कोई भी नहीं समझता, Love you Sir ❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️😘😘😘😘
@Innozant
@Innozant 2 года назад
Thanks Veeru..Keep Learning ♥️♥️
@jyotijha7910
@jyotijha7910 4 года назад
I really learn lot from your video lecture
@iamsainipawan
@iamsainipawan 3 года назад
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 🙏🙏🙏
@Innozant
@Innozant 3 года назад
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 ❤️❤️
@iamsainipawan
@iamsainipawan 3 года назад
@@Innozant 🙏🙏🙏🙏 sir
@bestsong340
@bestsong340 5 месяцев назад
Good knowledge sir
@videshacharjee9294
@videshacharjee9294 Год назад
Your teaching method excellent sir.
@Innozant
@Innozant Год назад
Thanks Videsh
@princemjprasanth8954
@princemjprasanth8954 Год назад
Thanks for the helpful video 🙏🙏🙏Sir
@bestsong340
@bestsong340 5 месяцев назад
Good work sir app bahut acha padata ho
@Innozant
@Innozant 5 месяцев назад
Thanks
@dhakafady774
@dhakafady774 9 месяцев назад
thanks a lot sir for the wonderful playlist , sir would you mind to make a playlist like this one about powerBI and DAX
@DineshSingh-kh7gf
@DineshSingh-kh7gf 3 года назад
सर आपकी विडियो बहुत अच्छी लगी । ऐसी विडियो तो यूट्यूब पर नही है ।
@Innozant
@Innozant 3 года назад
Thanks Dinesh Ji .Step by steo seekhiye Basic Excel playlist pejle finish kijiye Usle baad advance ke video in sequence dekhna aur seekhna hai
@RA-rh5lb
@RA-rh5lb Год назад
Thank you Sirji , Once again you rock!
@hiranaz5440
@hiranaz5440 2 года назад
Awesome sir you are great teacher
@Knu_804
@Knu_804 Год назад
मैं स्टेप बाय स्टेप ही आपके विडिओ देख रहा हूँ , फ्री में सीखने का मज़ा ही अलग है , धन्यवाद फार फ्री कोचिंग ।
@Innozant
@Innozant Год назад
👍
@AnitaSingh-mk3gi
@AnitaSingh-mk3gi 3 года назад
Sir Your way is easy to understand
@Innozant
@Innozant 3 года назад
Thanks Anita.❤️🙏 Recommend you take start your learning journey from playlist basic Excel..❤️🙏
@KrishivG
@KrishivG 3 года назад
Hi Sir, The way you explain is awesome... Can you please share some assignment on conditional formatting and (if function) logical function.. to practice 😊
@Innozant
@Innozant 3 года назад
Kindly check proquest assignment series playlist
@salmanishaq8705
@salmanishaq8705 2 года назад
Zbrdst concept 👌
@dubeypushpendra4558
@dubeypushpendra4558 Год назад
awesome video sir
@pritamdey4556
@pritamdey4556 3 года назад
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.
@Innozant
@Innozant 3 года назад
Thanks..dear...Basic excel ke playlist me in sequence videos rakhe hue hain..dear
@abdulrehmanmughal6217
@abdulrehmanmughal6217 2 года назад
Excellent
@shashikla4539
@shashikla4539 2 года назад
Please sir aap aise example or dijiye
@AbhishekSingh-ov1lj
@AbhishekSingh-ov1lj 4 года назад
your are great sir
@Innozant
@Innozant 4 года назад
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.
@mohitkumargupta2730
@mohitkumargupta2730 2 года назад
Thank you so much sir 🙏
@Innozant
@Innozant 2 года назад
Thanks Mohit Ji..Happy learning
@sawaimalhi8439
@sawaimalhi8439 3 года назад
kiya baat hai aaap ki sir love you
@Innozant
@Innozant 3 года назад
Thansk Sawai❤❤
@mrtikipresent518
@mrtikipresent518 3 года назад
THANK YOU SIR 👍👍👍👍👍👍👍
@Innozant
@Innozant 3 года назад
Thanks dear
@rakeshbhuva1983
@rakeshbhuva1983 Год назад
Auto hide & unhide row mate function joie chhe
@dicaprioleo8261
@dicaprioleo8261 3 года назад
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
@chetan1008
@chetan1008 3 года назад
IF & nested IF 👍👍👍
@Innozant
@Innozant 3 года назад
Thanks
@artiagnihotri4689
@artiagnihotri4689 4 года назад
Nice vedio sir
@PawanKumar-lc3du
@PawanKumar-lc3du 3 года назад
thanx sir ji, आप बहुत अच्छी तरह से समझाते है
@Innozant
@Innozant 3 года назад
❤️ Thanks
@vimaldewangan9309
@vimaldewangan9309 2 года назад
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)
@AbhishekSingh-ov1lj
@AbhishekSingh-ov1lj 4 года назад
nice video
@princerana6679
@princerana6679 2 года назад
Awesome
@gauravbhatia7987
@gauravbhatia7987 3 года назад
Good sir
@vimaldewangan9309
@vimaldewangan9309 2 года назад
Very interesting
@Innozant
@Innozant 2 года назад
👍
@nishimundan9414
@nishimundan9414 2 года назад
Please assist how can make numbers to words
@Innozant
@Innozant 2 года назад
Hi Nishi..Watch my lates video convett number to words
@React2trend
@React2trend 3 года назад
Sir aap offline class bhi dete ho main ghaziabad main rhta hu
@Innozant
@Innozant 3 года назад
Haan offline aur online live class chalta hai aap join kar sakte hain..For . more details kindly whatsapp on 7065069985
@dhramendraprajapati
@dhramendraprajapati 3 года назад
Baki basic excel video Playlist basic excel me jod sir.
@Innozant
@Innozant 3 года назад
Kya kehna chahte hain nhi aaya samajh dear..seprate playlist bana hua hai sabka dear
@dhramendraprajapati
@dhramendraprajapati 3 года назад
Samajh me aaya sir par kuch aur example kara do
@Altaf_Alam
@Altaf_Alam Год назад
❤️❤️
@prithvisahay269
@prithvisahay269 3 года назад
SIR, IF ke sath COUNTIF Use karke bhi pass fail result aa sakta h kya? Please reply sir🙏
@Innozant
@Innozant 3 года назад
Bilkul aa sakta hai..maine Interview cracker series me bhu karaye hainaur abhi aane wale maharaj series me again aise questions milenge aapko
@GaganDeep-rx5zx
@GaganDeep-rx5zx 3 года назад
17:07 Sir aap drag mai copy paste kase krte ho?
@Innozant
@Innozant 3 года назад
drag Matlab.. may be fill down fill right Kiya hoga .ctrl d ,ctrl r
@monikapawar320
@monikapawar320 3 года назад
Sir condition ke base per percentage kese nikale plz ans jarur dena
@Innozant
@Innozant 3 года назад
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)
@PawanSingh-fc8ex
@PawanSingh-fc8ex 2 года назад
Osssmmmmm
@KunalSingh-oy1ny
@KunalSingh-oy1ny 3 года назад
Sir, How to undo after evaluating a function
@Innozant
@Innozant 3 года назад
Ctrl z dear
@sameerahmad-gj4gm
@sameerahmad-gj4gm 3 года назад
Sir plz if and or ya wali serious Puri baana easy hard problem baatna plzzz sir
@Innozant
@Innozant 3 года назад
👍🙏♥️
@kaushikmishra2903
@kaushikmishra2903 3 года назад
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.
@Innozant
@Innozant 3 года назад
haan wo bhi ho sakta hai..countif se aur acha..aage ke videos me karaya hai Maine..seekhte chaliye step by step
@kaushikmishra2903
@kaushikmishra2903 3 года назад
@@Innozant yes sir mein bs Puch rha tha aap SE Jo mein Soch rha tha wo shi hai ya galat
@Innozant
@Innozant 3 года назад
sahi soch re h
@kaushikmishra2903
@kaushikmishra2903 3 года назад
@@Innozant thanks sir batane ke liye
@vikaskhadka3121
@vikaskhadka3121 3 года назад
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 ?
@Innozant
@Innozant 3 года назад
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
@rahulkashyap2704
@rahulkashyap2704 3 года назад
Ap help kr do na Sr ji Jo video dekhu us ka vhi example ya questions Doond ke kse kru mai🤕☹️
@Innozant
@Innozant 3 года назад
Haan direct link bhi daal rha hu..hald active kar dunga direct video example link
@jaishrisaxena1083
@jaishrisaxena1083 4 года назад
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.
@Innozant
@Innozant 4 года назад
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.
@jaishrisaxena1083
@jaishrisaxena1083 4 года назад
@@Innozant Thannnnks a looot, for kind response
@Innozant
@Innozant 4 года назад
Check Basic Excel Assignment Folder -Excel Intro , Cell Reference , Condition Formatting and Logical Function Assignment Practice folder uploaded.
@jaishrisaxena1083
@jaishrisaxena1083 4 года назад
@@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.!
@jaishrisaxena1083
@jaishrisaxena1083 4 года назад
@@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 .
@safiahashmi4673
@safiahashmi4673 2 года назад
Good 🇵🇰🇵🇰
@rahulkashyap2704
@rahulkashyap2704 3 года назад
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 🤕🤕
@Innozant
@Innozant 3 года назад
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
@rahulkashyap2704
@rahulkashyap2704 3 года назад
Ok sr ji
@shashikla4539
@shashikla4539 2 года назад
Please please please please please........... Sir
@uttamkumarpandey5669
@uttamkumarpandey5669 Год назад
deer si F9 karne ke bad return hona
@Innozant
@Innozant Год назад
Ctrl+z
@uttamkumarpandey5669
@uttamkumarpandey5669 Год назад
Thanks sir
@anshulmaurya2285
@anshulmaurya2285 7 месяцев назад
True me fail kar do sir
@anupganguly9377
@anupganguly9377 Год назад
Hii..galat na le..apne jo % nikala wo kahi avg to nahi tha .
@Innozant
@Innozant Год назад
Galat kisliye dear , percentage hi to nikala hoga ,jitna value hai use 5 se divide means 500
@syedtahirbukhari8377
@syedtahirbukhari8377 6 месяцев назад
Unnecessarily dragging. So boring taking more time unnecessarily
@Innozant
@Innozant 6 месяцев назад
Conceptual part is more important then implementation.Good in depth learning will take time.
Далее
Living life on the edge 😳 #wrc
00:17
Просмотров 5 млн
Living life on the edge 😳 #wrc
00:17
Просмотров 5 млн