AN ARRAY FORMULA in Slovenian translation

• formula s polji
• matrično formulo
• matrična formula
• formulo s polji
• formuli s polji

Examples of using An array formula in English and their translations into Slovenian

to shrink an array formula, you first delete the existing formula
želite skrčiti formulo polja, najprej izbrišite obstoječo formulo

An array formula entered in a range of cells is called a multi-cell formula.
Formula polja, ki vključuje več celic, se imenuje večcelična formula,

An array formula, in short, is a formula that gets applied to more than one cell.
Formula polja, skratka, je formula, ki se uporabi za več kot eno celico.

An array formula can perform multiple calculations
Formula polja lahko izvede več izračunov hkrati

If the formula is an array formula, you must first select all cells in the range of cells that contains the array formula:.
Če je formula formula polja, morate najprej izbrati vse celice v obsegu celic, ki vsebuje formulo polja:.

You can sum part or all of that data by creating an array formula in a single cell instead of dragging the formula down through the 1,000 rows.
Del ali vse te podatke lahko seštejete tako, da ustvarite formulo polja v eni celici namesto vlečenja formulo po vrsticah, 1000.

The key difference is that when using an array formula, you press Ctrl+Shift+Enter to enter your formula..
Ključna razlika je, da če uporabljate formulo polja, pritisnete Ctrl+ Shift+ Enter, če želite vnesti formulo..

When you use a named constant as an array formula, remember to enter the equal sign.
Ko poimenovano konstanto uporabite kot formulo polja, ne pozabite vnesti enačaja.

see Expand an array formula.
si oglejte razširi formulo polja.

you have to make this an array formula, otherwise the formula returns the VALUE! error!
morate to narediti kot formulo polja, sicer formula vrne VALUE! ŠTEV!

Every time you edit an array formula, the braces disappear
Vsakič ko urejate matrično formulo, zavite oklepaje({})

disappear from the array formula, and you must press Ctrl+Shift+Enter again to incorporate the changes into an array formula and to add the braces.
morate pritisnite Ctrl+ Shift+ Enter še enkrat, vključite spremembe v matrično formulo in dodati oklepaje.

In general, you do this by using the IF function in an array formula to determine whether each referenced cell contains a value,
V splošnem to naredite tako, da uporabite funkcijo IF v formuli, ki ji pravimo matrična formula, da ugotovite, ali vsaka sklicana celica vsebuje vrednost,

In general, you do this by using the IF function in an array formula to determine whether each referenced cell contains a value,
Na splošno to naredite tako, da uporabite funkcijo IF v matrična formula, s katero določite, ali naj vsak sklic na celico vsebuje vrednost,

In general, you do this by using the IF function in an array formula to determine whether each referenced cell contains a value,
Na splošno to naredite tako, da uporabite funkcijo if v formuli s polji, da ugotovite, ali ima vsaka referenčna celica vrednost,

When you enter the formula=TREND(B1:B3,A1:A3) as an array formula, it produces three separate results(22196,
Ko vnesete formulo =TREND(B1:B3;A1:A3) kot formulo polja, ta vrne tri ločene rezultate(22.196,

Note: This is an array formula and must be entered with Ctrl+Shift+Enter.
Opomba: To je formula s polji, zato jo morate vnesti s tipkami Ctrl+Shift+Enter.

thus making it an array formula.
tako da je formula polja.

An array, an array formula, or a reference to a range of cells for which you want the number of rows.
Matrika Obvezen. Matrika ali matrična formula oziroma sklic na obseg celic, za katerega želite število stolpcev.

the COLUMN function is not used as an array formula.
funkcija COLUMN ni uporabljena kot matrična formula(v tem primeru je kot rezultat vedno uporabljena prva vrednost matrike).