Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

How to Enter an Excel Formula With Price Plus Tax. Microsoft Excel is a spreadsheet program. It is a useful tool to quickly calculate values. By using formulas, users can calculate multiple values ...

Microsoft calls this process “spilling” and refers to all Excel formulas producing multiple results as “spilled array” formulas. Earlier Excel editions provide similar array functionality but require ...