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

👉 FREE Excel Course. ENROLL NOW https://hi.switchy.io/learnwithlokeshlalwanifreeexcelcourse

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

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

Download Excel Workbook: https://learn-with-lokesh-lalwani.thinkific.com/pages/downloadable-files

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

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

Or

Visit: https://www.nurturetechacademy.in/

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

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:https://www.youtube.com/channel/UCFAr3FQxRhSzVNOD3vq1gMQ/featured?sub_confirmation=1

Follow me on my Instagram for the latest updates:
https://www.instagram.com/learnwithlokeshlalwani/?hl=en

#learnwithlokeshlalwani #nurturetechacademy

Видео How to use IF, AND, OR functions in Excel (हिंदी में) канала Learn with LOKESH LALWANI