How to Use Logical Functions IF, AND, OR | HINDI |With Example Sheet
We have covered three logical functions in this video (IF,AND,OR). Please watch this video after watching this video you will be able to use all three functions without any support of help.
Excel sheet download link :-https://drive.google.com/file/d/1n9lc...
IF Function
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results.
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
The Excel AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE.
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
The OR function is a logical function to test multiple conditions at the same time. OR returns either TRUE or FALSE
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.
#asrknowledgecenter #iffunctioninexcel
#Learnexcelinhindi #logicalfunction
Our official email id :- [email protected]
The product I use:-
Smartphone: - https://amzn.to/3sA5H9g
Mic: - https://amzn.to/32ua22W
Tripod: - https://amzn.to/3tMZurG
Best Mobile Cover Brand: - https://amzn.to/2ROudqu
Memory Card: - https://amzn.to/3dx75VS
Wireless Keyboard and Mouse: - https://amzn.to/3xebfKe
Green Screen:- https://amzn.to/3v40KXH
Computer Table :- https://amzn.to/3ekuTv5
Extension Board:- https://amzn.to/32sGfrw
Laptop Table:- https://amzn.to/3xWwFfe
Смотрите видео How to Use Logical Functions IF, AND, OR | HINDI |With Example Sheet онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ASR Knowledge Center 28 Апрель 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 520 раз и оно понравилось 13 людям.