# IF Excel Function | How to use IF Function with Multiple Conditions?

WallStreetMojo
Published at : 18 Dec 2020
60313 views
139
51

In this video, on Excel IF Function, we are going to learn how to use IF function in excel using IF Excel Formula.

๐๐ ๐๐ฎ๐ง๐๐ญ๐ข๐จ๐ง ๐ข๐ง ๐๐ฑ๐๐๐ฅ
----------------------------------------

IF function in Excel checks the satisfaction of a condition and returns a value if it is (TRUE) and another value if the condition is not met (FALSE).IF function provides a decision - making capability to excel formula.

๐๐ ๐๐ฑ๐๐๐ฅ ๐๐จ๐ซ๐ฆ๐ฎ๐ฅ๐
--------------------------------

=IF (logical_test, [value_if_true], [value_if_false])

๐๐ซ๐ ๐ฎ๐ฆ๐๐ง๐ญ๐ฌ
-----------------------

Logical test โ A value that can be examined as TRUE or FALSE.

Value if true [ optional ] The value to return when TRUE is evaluated by logical test.

Value if false [ optional ] The value to be returned when FALSE is evaluated by logical test.

๐๐ก๐ข๐ง๐ ๐ฌ ๐ญ๐จ ๐๐๐ฆ๐๐ฆ๐๐๐ซ ๐ฐ๐ก๐ข๐ฅ๐ ๐ฎ๐ฌ๐ข๐ง๐  ๐๐ ๐๐ฎ๐ง๐๐ญ๐ข๐จ๐ง ๐ข๐ง ๐๐ฑ๐๐๐ฅ
-----------------------------------------------------------------------------------------------------------

#1 - It requires multiple open and closing parentheses whenever we use multiple IF statements, which often becomes hard to manage.

#2 - Use Nesting if function to a limited degree because multiple if statements takes a lot of thought to build them correctly.

To know more about ๐๐ ๐๐ฑ๐๐๐ฅ ๐๐ฎ๐ง๐๐ญ๐ข๐จ๐ง, you can go to this ๐ฅ๐ข๐ง๐ค ๐ก๐๐ซ๐:- https://www.wallstreetmojo.com/if-excel-function/

Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe - https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1