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

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/

Connect with us!
Youtube ► https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1
LinkedIn ► https://www.linkedin.com/company/wallstreetmojo/mycompany/
Facebook ► https://www.facebook.com/wallstreetmojo
Instagram ► https://www.instagram.com/wallstreetmojoofficial/
Twitter ► https://twitter.com/wallstreetmojo

Видео IF Excel Function | How to use IF Function with Multiple Conditions? канала WallStreetMojo