Learn Ms Excel IF Function / Formula
Time Stamps:
00:00 Excel IF Function
00:10 Starting IF Excel function
00:36 Explanation of Excel IF Function
01:36 Result
02:17 Wrap Up
02:45 Finish
#MsExcel
#ExcelIFFunction
Our Social Media:
Facebook: / naveedplace.comofficial
Twitter: / naveedplacecom
LinkedIn: / naveedplace-com
1. Excel Logical functions with example
2. logical function in excel
3. logical functions in excel 2007 with examples
4. IF Function in Excel
5. Excel Logical function
6. logical function definition
if function excel,if function with multiple conditions,if function between two values,if function,if function text logical test,if function in excel with multiple conditions,if function excel for grades,if function in google sheets,if function in ms excel,if function excel pass or fail
hello my friends my name is muhammad naveed and in this lecture i am going to you "IF
function" in ms excel so in order to start any function as you know that first we have to click on the cell double click definitely as you can see that now is showing uh indication that we are able to use any function so what i do i simply type is equals to as you know that in order to start any function we have to start any function with is equals to or plus or minus but most common is is equals to then after we will type the name of the function means of formula so here we are using if then we will definitely we will open the bracket and after this what i do i simply click on this cell and as i click on it as you can see that now showing the indication as well as showing the name or address of this cell as well means "A" is showing the column and "1" is showing the row so what i want i say that if the cell is equals to "Naveed" if this cell is equal to naveed then if it is true then give us yes sir
what i say if by saying that uh oh excel if this cell is equal to navi then if it's true then give us a yes sir if not so then give o okay and after this what i do i simply close this and i will click uh definitely i will say enter as you can see it's showing oh because there's nothing so as i type Naveed as you can see that now is showing yes sir why because i say to if that if this cell is equal to naveed means that whenever this cell has naveed so say me yes if not then they say me oh getting me so with the help of Excel if function we can you know we can give a little brain we can give mind to our excel that okay this order so definitely this is the work of Excel if function definitely we are saying that if this cell is equal to nathen give us yes if if not then give us a oh so in the place of naveed it can be naveedplays.com it can be the name of my friend it can be any name it can be anything getting me and one more thing is that for example if you talk about uh this we are using quotation marks here so if we have text means that
naveed or you can say abc this is called text so if you have characters or text definitely we use quotation marks if we have number for example we say one two three four so we we don't use quotation mark getting me so in this lecture what i want to teach you i won't teach you uh you can say uh Excel if function i hope you have understood for more videos lecture and exercises come to my website www.naveedplace.com i love you and i will meet you in the next lecture till then Allah Hafiz