10
best practices question on array formulas in google spreadsheet
say i have a column of value in column A. In column B, I'm multiplying by 10. I can use an array formula for the whole range or make the first individual formula in column B and paste down.
my question is which is better to use? is the array faster to calculate? is there any benefits from a speed point of view? I have big spreadsheets, I was wondering if this would make a difference.