{"id":2814,"date":"2017-03-09T17:08:20","date_gmt":"2017-03-09T20:08:20","guid":{"rendered":"https:\/\/importsheet.com\/?p=2814"},"modified":"2017-03-09T17:08:20","modified_gmt":"2017-03-09T20:08:20","slug":"formula-verdadeira-nas-planilhas-do-google","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/true-formula-google-sheets\/","title":{"rendered":"Como usar a f\u00f3rmula TRUE no Planilhas Google"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

The\u00a0<\/span>TRUE<\/a>\u00a0<\/span>formula in Google Sheets\u00a0returns the logical value \u2013 TRUE. Perhaps, it is one of the most simplest and straightforward formulas.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – One tool – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_colors_info=”{}” global_module=”50458″ theme_builder_area=”post_content”]\"\"<\/p>\n

\"39\"<\/p>\n

One tool to merge, split, and filter all your spreadsheet data<\/span><\/p>\n

Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Syntax<\/h3>\n

TRUE()<\/p>\n

Please note that the formula requires\u00a0no input arguments.<\/p>\n

In most of the scenarios, Google Sheets converts the literal text TRUE to the logical TRUE. So, to input the logical TRUE in a formula, we just have to key in the word TRUE directly and Google Sheets will interpret this as the logical TRUE.<\/p>\n

Also, apart from using this formula directly to generate the logical TRUE value, the Google Sheets application can do this in\u00a0many different ways. Some of the examples are shown in the snapshot below.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/TRUE-Formula-1.png” alt=”TRUE Formula 1″ title_text=”TRUE Formula 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Usage: TRUE Formula<\/h3>\n

As a standalone formula, TRUE() may not have many practical uses. But, its presence is quite ubiquitous. Because the logical expressions that return the logical values form the cornerstones of many conditional formulas. Without the interplay between the logical expressions and the logical TRUE and FALSE<\/a> values, many important formulas are as good as nothing. In the examples below, the conditional expressions enable the formulas to consider only the TRUE scenarios and ignore the ones that are FALSE.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/TRUE-Formula-2.png” alt=”TRUE Formula 2″ title_text=”TRUE Formula 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

TRUE Formula with AND, OR, and NOT<\/h5>\n

While we established that the logical TRUE and FALSE values are founding pillars on which many other formulas are build upon, we need to understand how the logical formulas AND, OR and NOT work with the logical TRUE and FALSE values.<\/p>\n

AND Formula<\/a><\/h5>\n

This returns a logical TRUE if we set every input parameter value to logical TRUE. If we set any of the parameters to a logical FALSE, then, as a result, the output value is a logical FALSE.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/TRUE-Formula-3.png” alt=”TRUE Formula 3″ title_text=”TRUE Formula 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

OR Formula<\/a><\/h5>\n

This returns a logical TRUE if we set any of the input parameter values to logical TRUE. Therefore, if we set every input parameter to logical FALSE, then the output value is a logical FALSE.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/TRUE-Formula-4.png” alt=”TRUE Formula 4″ title_text=”TRUE Formula 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

NOT Formula<\/a><\/h5>\n

This returns a logical TRUE if we set the input parameter to logical FALSE, and vice versa. Hence, the output is just the negation of the input logical value.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/TRUE-Formula-5.png” alt=”TRUE Formula 5″ title_text=”TRUE Formula 5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – Automate between spreadsheets – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_module=”50460″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

\"\"<\/p>\n

\"39\"<\/p>\n

Automate data transfers between spreadsheets
<\/span><\/p>\n

Find out how<\/a><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

The\u00a0TRUE\u00a0formula in Google Sheets\u00a0returns the logical value \u2013 TRUE. Perhaps, it is one of the most simplest and straightforward formulas. One tool to merge, split, and filter all your spreadsheet data Find out howSyntax TRUE() Please note that the formula requires\u00a0no input arguments. In most of the scenarios, Google Sheets converts the literal text TRUE […]<\/p>\n","protected":false},"author":40,"featured_media":14850,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"The TRUE<\/a> formula in google sheets returns the logical value - TRUE. Perhaps, it is one of the most simplest and straightforward formulas.\n

Syntax<\/h3>\nTRUE()<\/span><\/strong>\n\nPlease note that the formula requires no input arguments.\n\nIn most of the scenarios, Google Sheets converts the literal text TRUE to the logical TRUE. So, to input the logical TRUE in a formula, we just have to key in the word TRUE directly and Google Sheets will interpret this as the logical TRUE.\n\nAlso, apart from using this formula directly to generate the logical TRUE value, the Google Sheets application can do this in many different ways. Some of the examples are in shown the snapshot below.\n\n\"TRUE\n

Usage: TRUE Formula<\/h3>\nAs a standalone formula, TRUE() may not have many practical uses. But, its presence is quite ubiquitous. Because, the logical expressions that return the logical values form the cornerstones of many conditional formulas. Without the interplay between the logical expressions and the logical TRUE and FALSE values, many important formulas are as good as nothing. In the examples below, the conditional expressions enables the formulas to consider only the TRUE scenarios and ignore the ones that are FALSE.\n\n\"TRUE\n

TRUE Formula with AND, OR, and NOT<\/h5>\nWhile we established that the logical TRUE and FALSE values are founding pillars on which many other formulas build upon, we need to understand how the logical formulas AND, OR and NOT work with the logical TRUE and FALSE values.\n
AND Formula<\/h5>\nThis returns a logical TRUE if we set every input parameter value to logical TRUE. If we set any of the parameters to a logical FALSE, then, as a result, the output value is a logical FALSE.\n\n\"TRUE\n
OR Formula<\/h5>\nThis returns a logical TRUE if we set any of the input parameter values to logical TRUE. Therefore, if we set every input parameter to logical FALSE, then the output value is a logical FALSE.\n\n\"TRUE\n
NOT Formula<\/h5>\nThis returns a logical TRUE if we set the input parameter to logical FALSE, and vice versa. Hence, the output is just the negation of the input logical value.\n\n\"TRUE\n\n\u00a0\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-2814","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=2814"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2814\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/14850"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=2814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=2814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=2814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}