What is the translation of " AN ARRAY FORMULA " in Slovenian?

• 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

When entered as an array formula.
Ko jo vnesete kot formulo s polji,MODE.

The sum of the values of the cell ranges named Week1 and Week 2 as an array formula.
Vsota vrednosti obsegov celice»Teden1« in»Teden2« kot matrična formula.

If the formula is an array formula, press CTRL+SHIFT+ENTER.
Če je formula matrična formula, pritisnite CTRL+SHIFT+ENTER.

Note: The formula in cell C12 is an array formula.
Opomba: Formula v celici C12 je formula s polji.

An array formula, in short, is a formula that gets applied to more than one cell.
Formula s polji je formula, ki je uporabljena za več kot eno celico.

Problem: The formula has not been entered as an array formula.
Težava: Formula ni bila vnesena kot formula s polji.

If the formula is not entered as an array formula, the error VALUE! is returned.
Če formula ne vnesete kot matrično formulo, napake VALUE! vrne.

The formula=MODE. MULT(A2:A13)must be entered as an array formula.
Formulo =MODE. MULT(A2:A13) je treba vnesti kot formulo s polji.

Create an array formula or, you can read about detailed guidelines and examples of them here.
Ustvarjanje matrične formule, ali si lahko preberete o Podrobna navodila in primeri za njih tukaj.

If the formula is not entered as an array formula, the single result is 1.
Če formula ni vnesena kot formula s polji, je enojni rezultat 1.

You can also work around this issue by using SUM and IF functions together in an array formula.
Težavi se lahko izognete tudi tako, da uporabite funkciji SUM in IF skupaj v formuli s polji.

If the formula is not entered as an array formula, a single result(0) is returned in C5.
Če formula ni vnesena kot formula s polji, je v C5 vrnjen en rezultat(0).

You can also work around this issue by using SUM and IF functions together in an array formula.
To težavo lahko tudi obdelate tako, da uporabite funkcijo SUM in IF skupaj v formuli s polji.

If the formula is not entered as an array formula, a single result(0.25) is displayed in C6.
Če formula ni vnesena kot formula s polji, je v C6 vrnjen en rezultat(0,25).

Because the TRANSPOSE function is only used in array formulas, and that's how you finish an array formula.
Ker je funkcija prenosa uporabljena le v formulah s polji, in tako končate formulo s polji.

If the formula is not entered as an array formula, a single result(2) will be returned in cell C8.
Če formula ni vnesena kot formula s polji, je v C5 vrnjen en rezultat(0).

Be sure to select cells E2:E11, enter the formula =C2:C11*D2:D11, and then press Ctrl+Shift+Enter to make it an array formula.
Da izberete celice E2: E11, vnesite formulo= C2: C11*D2: D11, in nato pritisnite Ctrl+ Shift+ Enter, da bo matrično formulo.

If the formula is an array formula, select the range that contains the array formula:..
Če je formula matrična formula, izberite obseg, v katerem je matrična formula..

Note: To work correctly, the formula needs to be entered as an array formula in the Excel program.
Opomba: Za pravilno delovanje je treba formula v primeru v Excel vnesti kot formulo s polji.

If you enter OR as an array formula, you can test all values in a range against a condition.
Če vam ali kot matrično formulo, lahko preskusite vse vrednosti v določenem območju glede na dano stanje.

Because single-column areas have only one column number, it does not make a difference whether the formula is used as an array formula.
Ker imajo območja, ki se nahajajo v enem stolpcu, le eno številko stolpca, se nič ne spremeni, če je formula uporabljena kot matrična formula.

If the formula is not entered as an array formula, a single result(2) will be returned in cell C8.
Če formule ne vnesete kot formulo s polji, bo v celici C8 le en rezultat(2). 2.

An array formula references a range that doesn't have the same number of rows or columns as the range that contains the array formula..
Formula s polji se sklicuje na obseg, ki nima enakega števila vrstic ali stolpcev kot obseg, ki vsebuje formulo s polji..

Also remember that after you add a constant to an array formula, you press Ctrl+Shift+Enter to enter the formula..
Upoštevajte tudi, da po tem, ko dodate konstanto v matrično formulo, pritisnite CTRL+ SHIFT+ ENTER, da vnesete formulo..

If Value is an array formula, IFNA returns an array of results for each cell in the range specified in value.
Če je vrednost formula s polji, vrne IFERROR matriko rezultatov kot vrednost za vsako celico v navedenem obsegu.

If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is returned.
Če funkcije COLUMN s parametrom sklica na območje ne uporabljamo za matrično formulo, funkcija vrne le številko stolpca prve celice znotraj območja.

FREQUENCY would be entered as an array formula after we select a range of adjacent cells into which we want the returned distribution to appear.
FREQUENCY vnesete kot matrično formulo, potem ko ste označili obseg priležnih celic, v katerem hočete, da se prikaže porazdelitev, ki jo vrne funkcija.

When you use a named constant as an array formula, remember to enter the equal sign, as in =Quarter1, not just Quarter1.
Ko uporabite imenovano konstanto kot matrično formulo, ne pozabite vnesti znaka za enačaj, kot je v= Vnesitečetrtletje1, ne le Vnesitečetrtletje1.

The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows.
Funkcijo TRANSPOSE morate vnesti kot matrična formula v obsegu, ki ima tolikšno število vrstic in stolpcev, kot ima izviren obseg stolpcev in vrstic.