Google Sheets: Formula in an Array in a Formula

Question

I'm trying to find a way to consolidate formulas into 1 cell. As of right now i have 2 mildly complicated formulas using up multiple columns.

I'm trying to put the formulas as an array in a single cell.

To avoid confusing the matter, i've only included a simplified version of the formulas and only using 1 column.

Edit:

Here is the Spreadsheet in question, the Better Mobs sheet

Ok, so i tried to implement the solution and it didn't work the way i needed. Before i consolidate and just use 1 spreadsheet, the full formula in cell F1 is:

=match(max(F2:F),F2:F,0)+1&" - "&INDIRECT("A"&match(max(F2:F),F2:F,0)+1)

and cell F2 is:

=IFERROR(E269/ROUNDUP($C269/MAX(0,importrange("1rkS5zujl6oo66JNbhb8yWOjgOqRoXhvyGa-nr95krJ4","Damage Reward!$B$26")/2-$K269)*MAX((MIN(100+sqrt(importrange("1rkS5zujl6oo66JNbhb8yWOjgOqRoXhvyGa-nr95krJ4","Damage Reward!$B$27"))-sqrt(O269)-MAX($B269-importrange("1rkS5zujl6oo66JNbhb8yWOjgOqRoXhvyGa-nr95krJ4","Damage Reward!$B$3"),0)*5,100)/100),0)*2),"")

Answer 1

Does this formula work as you want in cell C1:

={MAX(ArrayFormula(IFERROR(B2:B*D2:D/E2:E)));ArrayFormula(IFERROR(B2:B*D2:D/E2:E))}