<\/p>\n
Syntax<\/h3>\n
XIRR(cashflow_amounts, cashflow_dates, [rate_guess])<\/strong><\/p>\n <\/p>\n [\/et_pb_text][et_pb_text admin_label=”Connections B – Merge, split, filter – Vertical” module_class=”sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” text_font=”||||||||” 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” saved_tabs=”all” global_colors_info=”{}” global_module=”50477″ theme_builder_area=”post_content”]<\/p>\n Merge, split, and filter spreadsheets<\/span> [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Let us try and apply this formula practically so that we get a better hang of how things work with XIRR formula in Google Sheets. Please have a look at the snapshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/1.-XIRR-formula-Illustration-Frame-1.webp” alt=”XIRR Formula: Usage” title_text=”xirr-formula-usage” _builder_version=”4.16″ 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 As shown in multiple examples above, the cash flows can be direct numeric values or we can also use a reference to the range of cells that hold the cash flow values.<\/p>\n The input range of dates cannot be plain text values. Either they should be values returned by formulas such as\u00a0<\/span>DATE<\/a>, TO_DATE etc. Or they can also be direct references to a range of cells that hold the dates.<\/p>\n What if we try the XIRR formula only with one directional cash flows? It coughs up a #NUM! error. That is because the XIRR formula needs both positive and negative cash flows for it to be able to calculate the rate of return.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/XIRR-formula-2-1.png” alt=”XIRR formula 2″ title_text=”XIRR formula 2″ _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_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Do you have a series of irregularly spaced cash flows of an investment? And you want to calculate the internal rate of return or annualized yield for that investment without the hassles of using complicated math? To our rescue, we have\u00a0XIRR\u00a0formula in Google Sheets.\u00a0The internal rate of return (IRR) calculates the rate of return without […]<\/p>\n","protected":false},"author":40,"featured_media":8340,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Do you have a series of irregularly spaced cash flows of an investment? And you want to calculate the internal rate of return or annualized yield for that investment without the hassles of using complicated math? To our rescue, we have XIRR<\/a> formula in Google Sheets. The internal rate of return (IRR<\/a>) calculates the rate of return without involving external factors, such as inflation or the cost of capital. Hence the term 'internal'. While IRR<\/a> formula calculates the rate or the return for periodic cash flows, the XIRR formula does so for non-periodic cash flows.\n\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\")
<\/p>\n![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\n
Regardless of the file format, Sheetgo can handle it.<\/span><\/p>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/available-on-google-workspace-button-text.webp\")
<\/a><\/p>\nUsage: XIRR formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nXIRR(cashflow_amounts, cashflow_dates, [rate_guess])<\/strong>\n
\n \t
Usage: XIRR formula in Google Sheets<\/h3>\nLet us try and apply this formula practically so that we get a better hang of how things work with XIRR formula in Google Sheets. Please have a look at the snapshot below.\n\n
![\"1.](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/1.-XIRR-formula-Illustration-Frame-1.png\")
\n\nAs shown in multiple examples above, the cash flows can be direct numeric values or we can also use a reference to the range of cells that hold the cash flow values.\n\nThe input range of dates cannot be plain text values. Either they should be values returned by formulas such as DATE<\/a>, TO_DATE etc. Or they can also be direct references to a range of cells that hold the dates.\n\nWhat if we try the XIRR formula only with one directional cash flows? It coughs up a #NUM! error. That is because the XIRR formula needs both positive and negative cash flows for it to be able to calculate the rate of return.\n\n![\"1.](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/1.-XIRR-formula-Illustration-Frame-2.png\")
\n\n ","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8310","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\/fr\/wp-json\/wp\/v2\/posts\/8310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=8310"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8310\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/8340"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}