Check out this post: Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts
Basically, you have to create an IF formula to check if there’s a value in a specific column (usually the 1st one) in order to conditionally perform the calculation, or leave the cell blank.