Inserting an Enter into a formula to make the result span multiple rows

[Mystix]

I do payroll for a construction company. When jobs are paid, I have formulas set up to make the information appear how I need it for the weekly payroll then I just reference those new cells in the payroll sheet itself to know how much everyone gets paid. My question is, is there a way to list out formula results spanning multiple rows with just one formula? Basically I want it to be like
=formula( result1, result2, result3, etc )
but I need it to display each result in it's own cell so it would be like
Result1
Result2
Result3

I've tried arraytotext but it seems like it would require a lot of modification to get it the way I want, and even then there would still be issues. Is there a way to insert an Enter command in textjoin maybe to list the various results in their own rows?

 

[Peter_SSs]

Would something like this work for you (though it seems more complicated than just putting the 3 formulas in their own cells )

22 05 22.xlsm
	A	B	C	D
1	1	8		6
2	2			32
3	3			1
4	4
Multiple rows

Cell Formulas
Range	Formula
D1:D3	D1	=TRANSPOSE(CHOOSE({1,2,3},SUM(A1:A3),A4*B1,A3-A2))
Dynamic array formulas.