MS Excel - IF Function
ฝัง
- เผยแพร่เมื่อ 13 ม.ค. 2018
- MS Excel - IF Function
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
To Buy Full Excel Course: bit.ly/38Jyu3p
Use coupon "TH-cam" to get FLAT 10% OFF at Checkout.
Check out latest Video Courses and eBooks : www.tutorialspoint.com/market...
In this video, we will explain how "if function" can be used in a variety of ways in your MS Excel worksheet.
For more updates on courses and tips follow us on:
Facebook: / tutorialspointindia
Twitter: / tutorialspoint
LinkedIn: / tutorialspoint
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
This did more for me in 5 minutes than what I learnt for 5 hours, from my college computer lab. Thank you boss❤
Sir, your classes are simple and easy to understand. I always refer your classes especially with functions. Thank you so much!
I completely like the way you explain. Though I am good in excel, i never had quality of explaining my knowledge to others. I am suggesting your videos to all my staffs after comparing others tutorial. Keep updating more and more.
I WILL LIKE TO ASK FOR YOUR HELP IN EXCEL
Could uh share your no.plz
SOS
Really bro, You juzz made me amaze !!! May Allah grant you, your precious family, your friends Hidayah soon and keep u all safe n healthy......Ameen.
No intro, no drama bazi..
I Appreciate your efforts😗
Thanks for all type of possible if functions 👍
Excellent. You make learning Excel more and more interesting for everyone. Keep up the good work and release such interesting videos more often. This video is three years old.
Thank You So Much Pawan Sir!
May God protect you and your family in this pandamic.
And I LIKE your way of explaination. THANK YOU FOR YOUR EFFORTS
There're more inside YOU. Something I've been looking for decades Mr. Pavan. I will be a lifetime student of yours. Many thanks
Haye, Muddo 6 bilood ka hor baad aragtidan dhiibataye, macallin ma ku noqotay bahalka ugaas?
Thanks sir. Even classes teachers who takes money from us can not teach like you. Great videos of excel.
You're one of the best teachers I've ever seen specially in Computer Education. Thank you very much Sir
Agreed 👍
Sir, You have made learning excel so simple, quick and easy. What I don't understand in my class, I refer to ur videos and clarify my doubts. Thank you so much:)
Came across your videos. I am not too computer savvy but understanding you was a breeze. Thank you so much.
You are amazing at Excel. I am learning so much from you. Keep it up
Sir, your every videos are very important. I have been trying to watch them not miss them. I have been learning a lot about Excel through these videos. Thanks
your pedagogical skills are absolutely brilliant
You are making videos in such a useful manner. Thanq very much for ur efforts.
This guy has a way of explaining this stuff in a simple way... Such a great tutor!!?
Thank you very much Mr. Pavan for explaining well as usual.
Awesome Explanation Bro 👏👏👏👏Thank you so much for imparting this knowledge 🙏
Love you sir...such a simple method of teaching which I really liked it🔥🔥🔥
⭐⭐ MICROSOFT EXCEL COURSE TO SKILLUP⭐⭐
ADVANTAGE OF THESE COURSES
01. REAL WORLD EXCEL PRACTICAL EXCEL SHEET
02. COMPLETION CERTIFICATE WILL BE PROVIDED
03. BEST DISCOUNTED PRICE
04. LIFE TIME ACCESS TO THE COURSE
05. MORE THAN 32000 ENROLL THESE COURSES WITH IN TWO MONTH
01 MOST ESSENTIAL AND POPULAR MICROSOFT EXCEL FORMULAS AND FUNCTIONS.
www.udemy.com/course/most-essential-popular-excel-formulas-and-functions/?couponCode=5766ADD876645FAEEACD
Coupon Code - 5766ADD876645FAEEACD
02 ADVANCED MICROSOFT EXCEL FORMULAS AND FUNCTIONS
www.udemy.com/course/advanced-microsoft-excel-formulas-functions/?couponCode=5AE0A4858DC79FBDF931
Coupon Code - 5AE0A4858DC79FBDF931
03 THE COMPLETE MICROSOFT EXCEL PIVOT TABLES AND CHARTS
www.udemy.com/course/the-complete-microsoft-excel-pivot-tables-and-pivot-charts/?couponCode=8CA1F7CDC5F9B5DB0F45
Coupon Code - 8CA1F7CDC5F9B5DB0F45
Thanks Pavan Sir. This videos are very simple and helpful.
Dear Pawan ,
Thankyou so much for making excel so easy for novice like me
Thank You Sir, God Bless You and Your Family, Please take care due to Corona Virus Outbreak.
Best excel learning videos ever seen. Kudos
Nicely taught! It cleared my multiple doubts.
EXCELLENT ANALYSIS AND METHODS OF TEACHING.
Hi Sir,
Thanks for the videos. explained in detail which helped to understand very easily. Thanks alot...............
Your explanations are really impressive. weldone sir.
your way of explanation is really awesome and easy to understand...
Would like to ask a question
I have in a data of a Store for entire year (365 days) where some days was open n some days closed.
What formula can I use as a subtotal to find out no.of days closed , by selecting the filter and subtotal shown the count of selected option in the filter
Superb explanations..simple and powerful
Explained really well. Great job.
Very efficient in the simplest way!
One of the best trainer
Thank you so much it's very helpful ❤️
Pahli baar main kisi ki puri English samjh pa rha hun 🤗
Thanks sir
Nice... Really... The explanation was too good
Very good class, clear and useful
Thank u for sharing ur knowledge..
Amazing Videos.
Hello! Can you please make a video to show how to use *Sum if" and "Count if" in excel...
Good presentation . Easy to understand
Ur looking like Sonu Sood from side (thumbnail) 💜💜
great video with good examples...thanks a lot.
I. Like your all video and i can easily understand
Good sir your way of teaching superb..
Thank you so much!!! I watched like 4 videos before yours and this gave the best explanation! thank you!! My formula came out finally!!!
Hmm
hello dear...first of all thanks for the lovely videos...
also i am very eager to know the source of such profound knowledge, which covers such detailed knowledge....
Sir I have windows 7 and the general option in home tab for date is not briht and am not able to select that hence what shud i do or require other option for the date placement
Sir tahan sutha teacher aayo- love from sindh
thank u very much for such beautiful explanation ..
Thank you sir u using simple English i understand very very easy thank you again sir
Very nice explanation...It is making learning excel so easy
Sidhi baat no bakwaas 😍🥰🥳
Hi everyone. I was from non IT background. I have worked for 7 years in manufacturing sector. I dint like my job so I wanted to change to IT. After trying hard, I got a job in an IT company. I work on inventory management mostly using ms excel. My problem now is my salary is only 14500per month which is definitely not enough to live in a city like Bangalore. I learnt excel because I am using it for a year now. How to apply for a better job having good knowledge in ms excel and good communication skills. Someone please suggest...
You looking very smart and your teaching very awesome
Thanks sir thanks for your sharing knowledge
Excellent sir. Very very nice teaching skill
Sir learnt a lot from you thanks sir g
SUPER SIR, LIKE YOU ARE PROFESSOR IN UNIVERSITY.
If Function made easy. Good explainer
Well explained. Nice presentation.
Amazing tutorials, simple and easy learn
Very helpful channel. Thank you sir
You explained so nicely sir !
You explained it very well 👍🏻
Thanks😊 it's so much helpful ...
Thank you so much
your all videos are too good & easy to learn
Thx sir for this video, this really helpful...🙂
The way of explanation is very nice
your teaching skills are amazing.. great tutorial #TrixCorner
Very clear explanation thanks
sir please tell me that how to make this video and how touching your hand in this cell
Superb, you are the best
Super :)
Thank you Master.
This one was very easy [only after watching the video]
Hi, Looking for a formula. Any help? Need to paste a cell with reference a text, if mismatch it should check for another cell and paste it
excellent video and Easley we can understand
great it's very easy. thanks a lot...
Hello sir your video has been very helpful i have an query how do we encode two fomulas in one cell for eg I am preparing tax invoice in excel sheet i wish to set up my company’s invoice in such a way where i could command CGST SGST & IGST IN SAME SHEET
Thank you sir good explanation
pwoli machaane thank you
Please zoom the excel hereafter
Thanks for uploading nice teaching sir
Can I Change Colour Cell Automatically When Report Number Change..
awesome bro. you are great.
Thank you Sir , you explaned it very well
God bless you, dude - you have a talent to teach lucidly. I like your clear accent too.
Love for Pakistan.
From*
Sir can it is possible to create 1 user form for update & save data automatically in three sheets like day sale sheet, monthly sale sheet and also update customer ledger also, if yes kindly make a video out off syllabus for practice propose
THANKS FOR TEACHING US .
Hurray! I got the basic concept of "If" function and applied in my excel sheet. It works. Very easy to understand.
Thanks - Teacher
Respect from Pakistan
⭐⭐ MICROSOFT EXCEL COURSE TO SKILLUP⭐⭐
ADVANTAGE OF THESE COURSES
01. REAL WORLD EXCEL PRACTICAL EXCEL SHEET
02. COMPLETION CERTIFICATE WILL BE PROVIDED
03. BEST DISCOUNTED PRICE
04. LIFE TIME ACCESS TO THE COURSE
05. MORE THAN 32000 ENROLL THESE COURSES WITH IN TWO MONTH
01 MOST ESSENTIAL AND POPULAR MICROSOFT EXCEL FORMULAS AND FUNCTIONS.
www.udemy.com/course/most-essential-popular-excel-formulas-and-functions/?couponCode=5766ADD876645FAEEACD
Coupon Code - 5766ADD876645FAEEACD
02 ADVANCED MICROSOFT EXCEL FORMULAS AND FUNCTIONS
www.udemy.com/course/advanced-microsoft-excel-formulas-functions/?couponCode=5AE0A4858DC79FBDF931
Coupon Code - 5AE0A4858DC79FBDF931
03 THE COMPLETE MICROSOFT EXCEL PIVOT TABLES AND CHARTS
www.udemy.com/course/the-complete-microsoft-excel-pivot-tables-and-pivot-charts/?couponCode=8CA1F7CDC5F9B5DB0F45
Coupon Code - 8CA1F7CDC5F9B5DB0F45
hurry? I think you mean Hurray
@@shaayeqparvez4551 Yes, spelling mistake. Thanks
Excellent explanation...!
Nice. Thank you Sir
Hiii
I Calculate one cell value and I want to that value should match the adjacent and greater value which I have already available.
The selected/suggested value may be is other Cell.
You brilliant thank you
What if we dont want to get a result as 1 or 0, can we nest a another logical function inside true value, like I want to get the min number in selected range of cells as a result.
Good sir super se bhi upar
I will type the data from the image into excel such as name, address, email, zip code etc. Is there any software or any way to check spelling mistakes in Excel from these images?
Very excellent explanation
How to find the count of total notice generated of a single sector , & same foumula apply of all sector and count should have printed in my next sheet ..
Thank you very much sir