Usage examples of "array formula" in English with translation to Russian

<>
Translations: all41 формула массива39 other translations2
Because the TRANSPOSE function is only used in array formulas, and that's how you finish an array formula. Дело в том, что функция ТРАНСП используется только в формулах массивов, которые завершаются именно так.
An array formula requires some special treatment: Instead of typing the braces yourself, you must instead press CTRL+SHIFT+ENTER — Excel then surrounds the formula =SUM(IF(A2:A6>20,A2:A6)) with the braces. У нее есть ряд особенностей. Не вводите фигурные скобки вручную: вместо этого нажмите клавиши CTRL+SHIFT+ВВОД, и Excel заключит формулу =СУММ(ЕСЛИ(A2:A6>20;A2:A6)) в скобки.
Examples of word usage in different contexts are provided solely for linguistic purposes, i.e. to study word usage in a sentence in one language and how they can be translated into another. All samples are automatically collected from a variety of publicly available open sources using bilingual search technologies.
If you find a spelling, punctuation or any other error in the original or translation, use the "Report a problem" option or write to us.

What is translation in context on PROMT.One

The “Contexts” section on PROMT.One is your translation-in-context tool that helps you find real examples of how words and phrases are used. Just enter a word and the service will show its translation in context — sentences from bilingual sources where this word is used together with its translation into the target language. This helps you understand subtle shades of meaning and correct usage in speech, whether it is a rare term or a common everyday phrase.

Millions of usage examples from real texts

Millions of translation examples are collected automatically from already translated texts: documents, websites, books, movie dialogues and more. Thanks to this, you can see a word in different situations — from formal business style to everyday colloquial speech. For convenience, the results can be filtered by a specific translation or topic, and you can also search within the examples found to quickly focus on the context you need.

How translation in context helps you learn a language

By using the “Contexts” section, you can effectively expand your vocabulary. The service clearly shows how idioms, phrasal verbs and polysemantic words are translated in different contexts. This makes language learning easier: you remember new words together with their real usage and immediately see correct translations in authentic, living language. Take advantage of context-based translation on PROMT.One — learning a language becomes easier and more engaging!