This function is abundantly used in the field including but not limited statistics, probability,\u00a0and computing. Here\u2019s how the function looks like when we plot it on the graph.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/LN-formula-1.png” alt=”LN formula 1″ title_text=”LN 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
Syntax<\/h3>\n
LN(value)<\/strong><\/p>\n Please note that input for\u00a0<\/span>value<\/strong>\u00a0<\/span>parameter must be positive. If we tried to use it with a zero or negative\u00a0<\/span>value<\/strong>, it throws up a #NUM! error. That is because the logarithm\u00a0is undefined for zero or negative numbers.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n It is now time that we practically apply the formula in Google Sheets application. And we may compare the graph with that of the output values. Please have a look at the following snapshot.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/LN-formula-Illustration-Frame-1.png” alt=”LN formula in Google Sheets: Usage” title_text=”ln-formula-usage” align=”center” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” 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 Similar to most other Google Sheets formulas, the LN formula accepts direct numeric values. It also is capable of consuming references to the cells that contain numeric values. The first example has an input that is a direct numeric value. Whereas all other examples have cell references for its input.<\/p>\n Now let\u2019s\u00a0observe the output values the formula returned. If we made a quick comparison of the output values against those in the graph, it certainly looks like it is following the graph in the first image. Let us venture out a little bit more and try to plot these output values on a graph using Google Sheets charts. And this is how it looks like. For sure, this chart resembles the first graph.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/LN-formula-3.png” alt=”LN formula 3″ title_text=”LN formula 3″ _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":" Spreadsheets of today are comprehensive tools that help us with everyday calculations. Be it elementary or advanced, they got a bundle of mathematical functions to offer. The\u00a0LN\u00a0formula in Google Sheets helps us to calculate the\u00a0natural logarithm\u00a0of a value. It evaluates the logarithm value considering the\u00a0Euler\u2019s number (e)\u00a0(a mathematical constant) for its base. This function is […]<\/p>\n","protected":false},"author":40,"featured_media":8971,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Spreadsheets of today are comprehensive tools that help us with everyday calculations. Be it elementary or advanced, they got a bundle of mathematical functions to offer. The LN<\/a> formula in Google Sheets helps us to calculate the natural logarithm<\/a> of a value. It evaluates the logarithm value considering the Euler's number (e<\/em>)<\/a> (a mathematical constant) for its base.\n\nThis function is abundantly used in the field including but not limited statistics, probability, and computing. Here\u2019s how the function looks like when we plot it on the graph.\n\n[caption id=\"attachment_9016\" align=\"aligncenter\" width=\"358\"]\n
Usage: LN formula in Google Sheets<\/h3>\n
![\"LN](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/LN-formula-in-Google-Sheets-Graph.png\")
Natural Logarithm Function [Image Source: Wikipedia][\/caption]\nSyntax<\/h3>\nLN(value)<\/strong>\n
\n \t
Usage: LN formula in Google Sheets<\/h3>\nIt is now time that we practically apply the formula in Google Sheets application. And we may compare the graph with that of the output values. Please have a look at the following snapshot.\n\n
![\"LN](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/LN-formula-Illustration-Frame-1.png\")
\n\nSimilar to most other Google Sheets formulas, the LN formula accepts direct numeric values. It also is capable of consuming references to the cells that contain the numeric values. The first example has an input that is a direct numeric value. Whereas all other examples have cell references for its input.\n\nNow let\u2019s observe the output values the formula returned. If we made a quick comparison of the output values against those in the graph, it certainly looks like it is following the graph in the first image. Let us venture out a little bit more and try to plot these output values on a graph using Google Sheets charts. And this is how it looks like. For sure, this chart resembles the first graph.\n\n![\"LN](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/LN-formula-Illustration-Frame-2.webp\")
","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8970","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\/8970","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=8970"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8970\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/8971"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}