The LN function in Excel accepts only a positive real number as its parameter.So, the value in the resultant cell is #NUM! Which shows the number is incorrect. Since the value is negative, the LN function in Excel returns an error indicating the value is erroneous. The number is -1.2, and we cannot calculate the log of a negative number. The first argument of the LN in Excel is B10, the number for which log is to be calculated. In this example, cell C10 has an LN formula associated with it. The error is #VALUE! which indicates the value is erroneous. So, the LN function in Excel returns an error when we cannot calculate the log for such a value. Unfortunately, the number is ‘abc,’ and we cannot calculate the log of non-numeric value. The first argument of the LN in excel is B8, the number for which log is to be calculated. In this example, cell C8 has an LN formula associated with it. So, the value in the resultant cell is 1.609437912. The number is 5, and the log of 5 is 1.609437912. The first argument of the LN is B6, the number for which log is to be calculated. In this example, cell C6 has an LN formula associated with it. The error is #NUM! Which indicates the number is erroneous. The LN function in Excel does not accept the number value as zero, so the error is thrown in return. Unfortunately, the number is 0, and we cannot calculate the log of 0. The first argument of the LN is B4, the number for which log is to be calculated. In this example, cell C4 has an LN formula associated with it. So, the value of the resultant cell is -0.693147. The first argument of the LN is B2, the number for which log is to be calculated. In this example, cell C2 has an LN formula associated with it.
HOW TO PLOT A GRAPH IN EXCEL USING A FUNCTION DOWNLOAD
You can download this LN Excel Template here – LN Excel Template Example #1 – Fractional number Refer to the examples given below to understand better. The Excel LN function can be inserted as a part of the formula in a worksheet cell as a WS function. The said function is a Worksheet (WS) function. read more! Indicating an error with the generated value. Sometimes, it is difficult to identify the kind of mistake behind this error. If the parameter is a non-numeric value, it returns an error with #VALUE Error With #VALUE #VALUE! Error in Excel represents that the reference cell the user has either entered an incorrect formula or used a wrong data type (mostly numerical data).If the parameter is zero, it returns an error with #NUM! Indicating an error with the number.If the parameter is a negative number, it returns an error with #NUM! Indicating an error with the number.The number must be a positive real number. It indicates the number for which the natural logarithm function is to be calculated. number = This is a required parameter.The LN formula has three arguments, out of which two are optional. The formula for the LN function in Excel is as follows: E.g., log(1) is 0, as shown in the LN function graph. In the LN function graph above, the X-axis indicates the number for which log is to be calculated, and the Y-axis indicates the log values.