How to use IF, AND, OR functions in Excel | Explain in Hindi | Ved Prakash Mandad
Hi,
Thanks for watching our video about Microsoft Excel.
This video covers the following functions:
Based on a particular condition, an IF function is all about either this or that. This is an if condition, so if we toss a coin and I choose heads, I will declare that I will win or lose.
Syntax:
Arguments for =IF(logical_Test, Value if true, Value if false):
Logical_Test is the state of your current situation.
Value_if_True: The value or calculation that needs to be shown here if the logical test is successful.
Value_if_False – The value or calculation that needs to be shown here if the logical_test proves to be false.
The "AND" function is used to determine whether all of the conditions are true or false.
The syntax AND(logical1, [logical2],...) is required for logical1. The first thing you want to test is a condition that can be evaluated as either TRUE or FALSE.
Logical2, ... Discretionary. Up to 255 additional conditions that you wish to test and that can be evaluated as either TRUE or FALSE.
OR If any of a set of conditions is true, an "OR" function will return "True" as its result.
OR(logical1, [logical2],...) is required in syntax. The first thing you want to test is a condition that can be evaluated as either TRUE or FALSE.
Logical2,... a choice Up to 255 additional conditions that you wish to test and that can be evaluated as either TRUE or FALSE.
Download Excel Workbook: https://docs.google.com/spreadsheets/...
===================================================
LIKE, SHARE, COMMENT, SUBSCRIBE TO MY CHANNEL, PRESS THE BELL ICON
ABOUT OUR CHANNEL
Our channel is about educational . We cover lots of cool stuff such as MS-WORD, EXCEL, POWER POINT, OUTLOOK
Computer Hardware
Computer Networking
Graphic Designing
Check out our channel here:
https://www.youtube.com/channel/UCCH4...
Don’t forget to subscribe!
We sell these awesome products, check them out here:
https://i360solutions.com/
FIND US AT
https://i360solutions.com/
GET IN TOUCH
Contact us on [email protected]
FOLLOW US ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!
Facebook: / i360logodesign
Instagram: / i360.solutions
Searching Keywords:
excel,
ms excel,
excel tutorial,
data entry in excel,
excel data entry,
excel data entry work,
ms excel tutorial,
excel work in electricity department,
excel practical,
excel work in bank,
excel work in hospital,
excel work in school,
excel tips and tricks,
excel interview question and answers,
excel tips,
data entry job in excel,
microsoft excel,
Tech computer,
excel tutorial in hindi,
excel in hindi,
maintain payroll in excel,
how to maintain salary in excel,
how to maintain salary sheet in excel,
bill in excel,
how to maintain wages sheet in excel,
quotation in ms excel,
excel tutorial,
excel,
how to data entry work in excel,
ms excel in hindi,
data entry in excel in hindi,
data entry in excel,
data entry form in excel,
excel me bill kaise banaye,
how to print title and headings in all excel pages,
how to entry bill in excel
#excel #i360solutions #functions #tutorial #numbers #formula #value #not #lookup #xlookup #microsoftexcel #msexcel #msexcelformula #msexcelformulas #msexcelvideos #or #excel #cells #learning #functions #flashcards #index #tutorial #max #reels #learn #bill #electricity