Syntax<\/h3>\n
RECEIVED(settlement, maturity, investment, discount, [day_count_convention])<\/strong><\/p>\n We get our\u00a0concepts much clearer when we try and apply them in practice. So, let\u2019s go straight ahead and dig into a few examples. Please take a look at the snapshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/RECEIVED-formula-in-Google-Sheets-1.png” alt=”RECEIVED formula in Google Sheets 1″ title_text=”RECEIVED formula in Google Sheets 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.27.2″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Like in other Google Sheets\u2019 financial formulas, the\u00a0settlement<\/strong>\u00a0and\u00a0maturity<\/strong>\u00a0parameters expect valid dates. Therefore, we need to either use outputs from functions such as\u00a0DATE<\/a>,\u00a0TO_DATE.<\/a>\u00a0Or, they can also be references to other date\u00a0type cells. Google Sheets may return parsing errors if we enter direct text values for dates.<\/p>\n While all the formulas in the above image are essentially the same, the output values seem to vary. This is because of the different\u00a0day_count_convention<\/strong> methods we are using<\/p>\n <\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Depending on the buyer\u2019s preferences, there are periodic investments as well as fixed investments to choose from. Suppose that we purchased a fixed-income security today. We would certainly be interested to know how much we receive when the investment matures. The\u00a0RECEIVED\u00a0formula in Google Sheets appropriate for this\u00a0context. Syntax RECEIVED(settlement, maturity, investment, discount, [day_count_convention]) settlement \u2013\u00a0is […]<\/p>\n","protected":false},"author":40,"featured_media":8386,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Depending on the buyer's preferences, there are periodic investments as well as fixed investments to choose from. Suppose that we purchased a fixed-income security today. We would certainly be interested to know how much we receive when the investment matures. The RECEIVED<\/a> formula in Google Sheets appropriate for this\u00a0context.\n\n
\n
Usage: RECEIVED formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nRECEIVED(settlement, maturity, investment, discount, [day_count_convention])<\/strong>\n
\n \t
\n \t
Usage: RECEIVED formula in Google Sheets<\/h3>\nWe get our\u00a0concepts much clearer when we try and apply them in practice. So, let's go straight ahead and dig into a few examples. Please take a look at the snapshot below.\n\n
![\"RECEIVED](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/RECEIVED-formula-Illustration-Frame-1.png\")
\n\nLike in other Google Sheets' financial formulas, the\u00a0settlement<\/strong>\u00a0and\u00a0maturity<\/strong>\u00a0parameters expect valid dates. Therefore, we need to either use outputs from functions such as\u00a0DATE<\/a>,\u00a0TO_DATE.<\/a>\u00a0Or, they can also be references to other date\u00a0type cells. Google Sheets may return parsing errors if we enter direct text values for dates.\n\nWhile all the formulas in the above image are essentially the same, the output values seem to vary. This is because of the different\u00a0day_count_convention<\/strong>\u00a0methods we are using.\n\n
\n\nFeatured Image - Designed by Jcomp \/ Freepik<\/a><\/small>","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8385","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\/es\/wp-json\/wp\/v2\/posts\/8385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=8385"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8385\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/8386"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}