How to combine a range and cell into a new range within a formula in Excel

I have a formula in Excel that takes an array/range of values as one of the input.

I have a range of values, let's say A1:A6, and a single cell C11. I want to combine the range with the single cell in that exact order, i.e. the result of the combination is an array/range of values will start from A1 to A6 and will end with C11. I don't want the text value by concatenating A1:A6 with C11, rather, I want the array of data containing those in A1:A6 and C11.

For example, in the pic above, I want to apply the array containing the values of A1:A6 and C11 to the formula/function called IRR which takes an array as the first argument.

How can I do that in as part of a formula?

For what it's worth, you can easily accomplish what you're trying to do in Google Sheets using curly brackets: {range1 ; range2} (combining vertically) or {range1, range2} (combining horizontally). This will create a new array of the values from range1 followed by the values from range2 (either vertically or horizontally, depending on whether you separated with a semi-colon or a comma).