How to use IF, AND, OR functions in Excel (हिंदी में)
Автор: Learn With Lokesh Lalwani
Загружено: 2019-04-01
Просмотров: 1726311
Описание:
👉 FREE Excel Webinar. REGISTER NOW
https://event.webinarjam.com/register...
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.thi...
=========================================================
For any training, requirement - [email protected], [email protected]
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: / @learnwithlokeshlalwani
Follow me on my Instagram for the latest updates:
https://www.instagram.com/learnwithlo...
______________________________________________________________________
⚠️ Disclaimer:
Ye video sirf educational purpose ke liye hai. Jo earnings mention ki gayi hain, wo estimated figures aur personal experience par based hain. Aapki actual earnings aapke effort, market demand aur platform policies par depend karegi. Is video mein kisi bhi guaranteed income ka promise nahi hai. Koi bhi online earning method shuru karne se pehle apni research zaroor karein.
🔔 Video pasand aaye to Like, Share & Subscribe zaroor karein!
📩 Agar koi sawaal hai, to comment section mein pooch sakte hain!
#EarnOnline #SecondSalary #Freelancing #SideIncome #PassiveIncome
#learnwithlokeshlalwani #nurturetechacademy
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: