Use the Nested IF Function
About the Lecture
The lecture Use the Nested IF Function by Sonic Performance is from the course Analyzing Data with Logical Functions in Excel 2013. It contains the following chapters:
- Introduction
- The Nested IF Function
- Summary
Included Quiz Questions
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?
- MAX
- MIN
- AVERAGE
- IF
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?
- FALSE
- A #NAME? error
- TRUE
- A #DIV/0! error
Author of lecture Use the Nested IF Function
Sonic Performance
Customer reviews
5,0 of 5 stars
| 5 Stars |
|
5 |
| 4 Stars |
|
0 |
| 3 Stars |
|
0 |
| 2 Stars |
|
0 |
| 1 Star |
|
0 |
