Help with "LARGE" formula

[jjjjj55555]

Hi All,

I'm using the excel built in formula LARGE(array,k). I know I can use it in an example like this where I select a range in the array section

=LARGE (A1:A4,3) it will return the 3rd largest value from the 4 cells in my array.

My desired use is for the array to consist of a set of 2 fixed numbers and a formula, not by selecting a range. For example something like this:

=LARGE (0,5,A1/B2 - 3,2)

In this example I want it to return the middle value of the 3 values. Say the value of A1 is 10 and B1 is 2, thus the 3 numbers in my array are 0, 5, 2.
0
5
A1/B1 - 3


Is this possible to build into the formula? I'm not sure the syntax of how to create this formula. I'm aware I can populate 3 cells with my 3 values above and do this using the array selection I mentioned in the 1st row, that isn't the answer I'm looking for.

Thanks!

[Tony Valko]

Maybe this...

=MEDIAN(0,5,A1/B2 - 3)

[jjjjj55555]

Good answer Tony, thank you very much.

[Tony Valko]

You're welcome. Thanks for the feedback!