Using functions in LARGE-function

[Dudemeister]

I want the largest number out of three formulas, but I dont want to get it from a cell, can't I just put the formula directly in the LARGE-function? When I do I just get errors. I have tried with {} around the formulas as well.

Ex: =LARGE(20:B13/30:B11/300;1) instead of =LARGE(B11:B15:B18;2)

Can anybody help? I asume it's possible somehow.

[davesexcel]

I want the largest number out of three formulas, but I dont want to get it from a cell, can't I just put the formula directly in the LARGE-function? When I do I just get errors. I have tried with {} around the formulas as well.

Ex: =LARGE(20:B13/30:B11/300;1) instead of =LARGE(B11:B15:B18;2)

Can anybody help? I asume it's possible somehow.

I am unsure what the formula is

[royUK]

I don't think that the Large function allows for multiple ranges.

[shg]

How about

=MAX(LARGE(Array1, Size1), LARGE(Array2, Size2), ...)

[daddylonglegs]

If you only want the largest value try

=MAX(20;B13/30;B11/300)

If you want the second largest

=LARGE(CHOOSE({1;2;3};20;B13/30;B11/300);2)

[shg]

=LARGE(CHOOSE({1;2;3};20;B13/30;B11/300);2)

Very nice.