Hello, everybody, welcome to the second dashboard. In this video, we will learn how to use min if with multiple parameters. In the previous video, we learned how to create max if, with multiple parameters, the concept remains the same, only the formula is changing. So to make the work easier, we'll be copying the above formula and pasting it below. So now the array has been taken care of. In place of Max, we just have to put in min and Ctrl, Shift Enter.

And there it is. If I was the one writing this formula, it would have been equals to if and we're doing this and a little bit faster. So I'll just complete the formula. And you can watch it over. Once the formula is done, simply progress Ctrl Shift Enter and there it is the formula still remains the same. So we're dragging it down and then to the right.

Right there it is based on the conditions that I've defined, I have the minimum salary given out for these particular departments for the respective events labs. Let me just format it. So there it is. In the next video we'll be starting to create and lay down the base for our dashboard. Till then keep practicing. See you in the next video.

Thank you