Scribd
Upload
46 views1 page

Excel 44

The document explains how to create and edit array formulas in Excel, emphasizing the importance of selecting a range of the same shape as the values used in the calculation. It details the steps to enter an array formula using Ctrl+Shift+Enter and notes that braces cannot be manually added to make a formula an array formula. Additionally, it highlights potential issues that arise from incorrect range selection, such as duplicate or incomplete results.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
46 views1 page

Excel 44

The document explains how to create and edit array formulas in Excel, emphasizing the importance of selecting a range of the same shape as the values used in the calculation. It details the steps to enter an array formula using Ctrl+Shift+Enter and notes that braces cannot be manually added to make a formula an array formula. Additionally, it highlights potential issues that arise from incorrect range selection, such as duplicate or incomplete results.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Create array formulas

the formula =B1*B4:B6. Note that you must select a range of the same shape as the
values you’re using in the calculation. (For example, if the value range is three columns
wide by one row high, the target range must also be three columns wide by one row
high.) If you enter the array formula into a range of the wrong shape, Excel displays
duplicate results, incomplete results, or error messages, depending on how the target
range differs from the value range.
3
When you press Ctrl+Shift+Enter, Excel creates an array formula in the selected cells.
The formula appears within a pair of braces to indicate that it is an array formula.

An array formula calculates multiple results

IMPORTANT You can’t add braces to a formula to make it an array formula. You must
press Ctrl+Shift+Enter to create it.

To create an array formula

1. Select the cells in which you want to display the formula results.

2. In the formula bar, enter the array formula.

3. Press Ctrl+Shift+Enter.

To edit an array formula

1. Select every cell that contains the array formula.


2. In the formula bar, edit the array formula.

3. Press Ctrl+Shift+Enter to re-enter the formula as an array formula.

91

You might also like