92,804 views
In this tutorial I will show you the IF and OR functions combined with Excel. With the normal IF function you can only specify one condition. You could of course nest the IF function but there are other functions you can use to specify conditions. One of these is the OR function. Here it is sufficient that just one of a number of conditions is met for the OR function to return TRUE. As soon as the OR function returns TRUE, TRUE is also returned for the IF function and the 2nd parameter is executed (i.e. what should happen if the condition is met). If all conditions are not met, the OR function returns FALSE and passes the result to the IF function. The IF function then outputs the 3rd parameter (i.e. what should happen if the condition is not met). You can download the project file here: https://toptorials.com/wenn-und-oder-... If you are also interested in other tutorials with the IF function: The simple IF function: • IF Then Else FUNCTION (Excel) The IF function combined with AND: • IF and AND combined (Excel) The nested IF function: • Nested IF function completely... An easy-to-understand tutorial for beginners in the area of: Excel You can also find many other tutorials and downloads on my website: https://toptorials.com This instruction / learning video is in German. #Excel #microsoftexcel #learningvideo