Hi Everyone My Name Is Azeem Khan And I Make Educational Videos.
My dear brothers & sisters, this era of technologies is nothing without a computer here. So on this channel, I have brought for you Quick Book, Quick Book Tips, MS Excel, Excel Tips, Word Tips, MS Access, MS PowerPoint, Computer Tricks in Urdu, Computer Tips, HTML, CSS, Internet and Technology will bring lots of videos and even more useful videos which will always be your Will be useful to increase your computer knowledge and will make you a computer expert.
This video Published on september 29 2020
In This video we have explained MS Excel-If Function (Basic To Advance) If Function with AND & OR In Hindi (Accounts Information)
We cover a few examples in this tutorial including:
1. Simple IF function (also with greater than or less than checks).
2. IF Formula together with AND logical test to decide outcome if more than one condition is met.
3. Nested IF formula (an IF inside another IF) to check for multiple criteria.
4. IF formula with OR function (to check if "either" condition is met and then decide the outcome).
5. We also take a look at using formulas (other calculations) inside the IF function and finally:
6. How to use symbols as the result of the IF formula
Your IF formula isn't working? One of the main mistakes is the "else" argument. That's the last argument inside the IF function. Make sure you haven't forgotten to specify what should happen "if" the condition isn't met. In case you have more than one condition, here's the place to add the second "if" statement. An IF formula inside another IF formula is called a nested if function.
Accounts Information presents How to use IF AND OR Formula Together in Excel in Hindi. This video explains you in detail each formula if and or formula in excel with examples.
(1) IF Function : The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE.
How to use IF function in excel
Syntax of IF Function : IF( condition, [value_if_true], [value_if_false] )
(2) OR Fucntion : he Microsoft Excel OR function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.
How to use AND function in excel
Syntax of IF Function : OR( condition1, [condition2, ... condition_n] )
(3) And Function : The Microsoft Excel AND function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.
How to use OR function in excel
Syntax of IF Function : AND( condition1, [condition2], ... )
It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down. On youtube, only just few videos are available on How to use Excel Logical Functions – IF AND OR Nested IF in Hindi.
Thanks for watching. It is humble request to you please subscribe
My Channel / accounts Information
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
If You are computer user, excel user, ms word user, power point user, sql user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel Accounts Information and subscribe.
Checkout some of our other training on YouTube:
85) • MS Excel-Vlookup Function/Formula In Hindi... (Vlookup Function/Formula In Hindi)
84) • MS Excel-ShortCut Key & Excel Tips You Sho... (ShortCut Key & Excel Tips)
83) • MS Excel- How To Use Concatenate Formula I... (How To Use Concatenate Formula Basic To Advance)
82) • MS Excel-Excel Shortcut Key in Hindi (You ... (Excel Shortcut Key)
We always provide usful content on the Accoounts Information 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 Simple language available in Hindi You can visit our website for more information.
It is our effort to get this information useful for all types of Excel users, computer users and internet users.
So my dear brothers and sisters, our job is to bring you one useful video for you, to increase your computer knowledge and to subscribe to the channel. So just subscribe to the channel and also press the bell so that our videos keep watching you.
Pakistan Zindabad:________
Please Support me Friends & Show Your Love By like, Share, Comments.________
Subscribe:________
Please Dont Forgot to Subscribe Us._______
Thanks All "Accounts Information" Supporters Love U ?._______
___________________________________________________
Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day.....____
Информация по комментариям в разработке