How to show some results used in a function

Copper Contributor
I'm looking for some results using a function 
With the same conditions
The function displays the appropriate first result
How can I view the second, third and fourth result?
I have an excel 2016
1 Reply

Hi @ggsmile4u

 

if I understand correctly, there would be more results for your function, but it only delivers the first one.

Generally, in Excel 2016 it is tricky to do something like this, you probably need to use so-called array-functions.

 

To give you a better advice: Could you please upload an example of your file with the respective formulas?