Examples with "enter an array formula" and their translation in Japans
We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
Cannot enter an array formula into a range of cells which are not all locked or all unlocked.
If you use this property to enter an array formula, the formula must use the R1C1 reference style, not the A1 reference style (see the second example).
To enter an array formula, select the cell that contains the formula, press F2, and then press CTRL+SHIFT+ENTER.
配列数式を入力するには、数式を含むセルを選択し、F2 キーを押して、Ctrl キーと Shift キーを押しながら Enter キーを押します。
To enter an array formula, press CTRL+SHIFT+ENTER.
配列数式を入力するには、 Ctrl キーと Shift キーを押しながら Enter キーを押します。
Andere resultaten
If you are creating a reference in a single cell or a range of cells, and are referring to another range of cells, press CTRL+SHIFT+ENTER to create an array formula.
単一セルまたはセル範囲に参照を作成し、他のセル範囲を参照している場合は、Ctrl キーと Shift キーを押しながら Enter キーを押して、配列数式を作成します。
Select the range of cells in which you want to enter the array formula.
配列数式を入力するセル範囲を選択します。
Entering or editing an array formula, and then pressing ENTER
配列数式を入力または編集して Enter キーを押した
Entering or editing an array formula, and then pressing ENTER
配列数式を入力または編集し、Enter キーが押された
Enter the following formula as an array formula
次の数式を行列式として入力します。
Some worksheet functions return arrays of values, or require an array of values as an argument. To calculate multiple results with an array formula, you must enter the array into a range of cells that has the same number of rows and columns as the array arguments have.
To use values returned as an array, enter the INDEX function as an array formula in a horizontal range of cells for a row, and in a vertical range of cells for a column.
If the formula is an array formula, press CTRL+SHIFT+ENTER.
配列数式の場合は、Ctrl キーと Shift キーを押しながら Enter キーを押します。
The formula in the example must be entered as an array formula. After copying the example to a blank worksheet, select the range A9:B9 starting with the formula cell. Press F2, and then press CTRL+SHIFT+ENTER. If the formula is not entered as an array formula, the single result is 1.463275628.
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.