Array function A formula that calculates more than one variable at the same time. You must use Ctrl+Shift+Enter to complete an array function; the completed formula will be contained with braces ….