👉 FREE Excel Webinar. REGISTER NOW
[ Ссылка ]

In this video, we will talk about “How to use IF, AND, OR function in Excel (in Hindi)”.

=========================================================

Download Excel Workbook: [ Ссылка ]

=========================================================

For any training, requirement - trainingbylokesh@gmail.com, info@nurturetechacademy.in

Or

Visit: [ Ссылка ]

=========================================================

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:[ Ссылка ]

Follow me on my Instagram for the latest updates:
[ Ссылка ]

#learnwithlokeshlalwani #nurturetechacademy

свернуть