How to use IF, AND, OR functions in Excel (हिंदी में)

👉 FREE Excel Webinar. REGISTER NOW
event.webinarj...
In this video, we will talk about “How to use IF, AND, OR function in Excel (in Hindi)”.
=========================================================
Download Excel Workbook: learn-with-lok...
=========================================================
For any training, requirement - [e-mail], [e-mail]
Or
Visit: www.nurturetec...
=========================================================
Following functions are being covered in this video:
IF
If a function is all about either this or that based on a certain condition. If we toss a coin and I choose heads, then I'll say if heads come I’ll win else I’ll lose, this is an if condition.
Syntax:
=IF(logical_Test, Value_if_true,Value_if_False)
Arguments:
Logical_Test - It is the condition of your present scenario.
Value_if_True - If logical_test comes out to be true then what value or calculation needs to be shown here.
Value_if_False - If logical_test comes out to be false then what value or calculation needs to be shown here.
AND
When we would like to check that if all the conditions are true or not then we use “AND” function.
Syntax
AND(logical1, [logical2], ...)
Logical1 Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.
Logical2, ... Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.
OR
An “OR” function will give “True” as a result if anyone out of a set of conditions is true.
Syntax
OR(logical1, [logical2], ...)
Logical1 Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.
Logical2, ... Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.
===================================================
LIKE, SHARE, COMMENT, SUBSCRIBE TO MY CHANNEL, PRESS THE BELL ICON
For more such videos subscribe our channel: / @learnwithlokeshlalwani
Follow me on my Instagram for the latest updates:
www.instagram....
#learnwithlokeshlalwani #nurturetechacademy