Yahoo Αναζήτηση Διαδυκτίου

Sign In

Αποτελέσματα Αναζήτησης

  1. www.exceldemy.com › take-log-of-negative-numbers-in-excelHow to Take Log of Negative Numbers in Excel: 3 Ways

    5 Ιουλ 2024 · The logarithm function provides an imaginary number as a result for negative numbers and isn’t defined for them in Excel. You’ll need to go around that restriction if you want to get meaningful results. Method 1 – Utilizing the IF Function to Take a Log of Negative Numbers. Use the following formula in the D5 cell.

  2. www.automateexcel.com › functions › log-formula-excelExcel LOG Function - Calculate logarithm (log) - Automate Excel

    9 Νοε 2023 · Learn how to use Excel's LOG function for both Mac and PC. Includes numerous formula examples in Excel and VBA (WITH PICTURES).

  3. www.excelfunctions.net › excel-log-functionExcel LOG Function

    If you get an error from the Excel Log function, this is likely to be one of the following: #NUM! Occurs if either the supplied number argument or the supplied [base] argument is negative or zero. #DIV/0! Occurs if the supplied [base] argument is equal to 1. #VALUE!

  4. www.exceldemy.com › calculate-log-in-excelHow to Calculate a Logarithm in Excel (6 Methods) - ExcelDemy

    16 Ιουλ 2024 · For calculating log, there are pre-defined Formulas which are called Functions. Here we've shown 6 unique methods to calculate log in excel.

  5. support.microsoft.com › en-us › officeLOG function - Microsoft Support

    This article describes the formula syntax and usage of the LOG function in Microsoft Excel. Returns the logarithm of a number to the base you specify. LOG (number, [base]) The LOG function syntax has the following arguments: Number Required. The positive real number for which you want the logarithm. Base Optional. The base of the logarithm.

  6. www.exceldemy.com › excel-log-functionHow to Use LOG Function in Excel: 10 Methods - ExcelDemy

    20 Μαΐ 2024 · This formula returns the negative 10-based logarithm of the Hydrogen ion concentration values i.e. PH values. Determine the nature of the solutions based on these PH values. Type the formula below in Cell E5 and press Enter key to get the required nature of the solution.

  7. www.excelmojo.com › log-excel-functionLOG Excel Function - Formula, Step-by-Step Examples, How to Use?

    If any of the supplied LOG Excel function arguments are negative or zero, the LOG function will throw the #NUM! error. If the provided base value is 1, the LOG function output will be the #DIV/0! error. If any of the provided LOG Excel function arguments are not numbers, the LOG () returns #VALUE! error.