Der Vortrag „Use the Nested IF Function“ von Sonic Performance ist Bestandteil des Kurses „Analyzing Data with Logical Functions in Excel 2013“. Der Vortrag ist dabei in folgende Kapitel unterteilt:
At a minimum, to answer the question "Which product had the highest number of units sold last month?" you will need to utilize which function?
Cell A1 contains the value 10. Cell A2 contains the value 20. Cell A3 contains the value 40. What will the function AND(A1 < A2, A3 > 50) return?
5 Sterne |
|
5 |
4 Sterne |
|
0 |
3 Sterne |
|
0 |
2 Sterne |
|
0 |
1 Stern |
|
0 |