In Microsoft Excel, a function is a predefined method that makes calculations utilizing particular values known as arguments in a selected order or Construction. On this tutorial, we’ll clarify how to use the LOG and LOG10 Features in Excel. The LOG and the LOG10 features are each Math and Trigonometry features. The LOG function returns the logarithm of a quantity to the base you specify, and the LOG10 returns the base -10 logarithm of a quantity.
Under are the formulation and syntax of each the LOG and LOG10 features.
LOG
LOG (quantity, [base])
Number: The constructive actual quantity for which you need the logarithm. It’s required.
Base: The bottom of the logarithm. Non-obligatory.
LOG10
LOG10 (quantity)
Quantity: The constructive actual quantity for which you need the base-10 logarithm.
How to use the LOG function in Excel
- Launch Microsoft Excel.
- Enter your information or use present information.
- Kind into the cell the place you need to place the consequence =LOG (A4, B4).
- Press Enter to see the consequence. The result’s 6.
- Now drag the fill deal with down to see the different consequence.
- There are two different strategies to use the LOG function.
Technique one is to click on the fx button on the high left of the Excel worksheet.
An Insert Function dialog field will seem.
Inside the dialog field, in the part Choose a Class, choose Math and Trigonometry from the listing field.
In the part Choose a Function, select the LOG function from the listing.
Then click on OK.
A Function Arguments dialog field will open.
Kind into the entry packing containers the cell that incorporates the quantity you need to calculate.
Then click on OK.
Technique two is to click on the Formulation tab and click on the Math and Trigonometry button in the Function Library group.
Then choose LOG from the drop-down menu.
A Function Arguments dialog field will open.
Comply with the identical technique in Technique 1.
Then click on OK.
How to use the LOG10 features in Excel
- Enter your information or use present information.
- Kind into the cell the place you need to place the consequence =LOG10(A4).
- Press Enter to see the consequence. The result’s 1.653213.
- Now drag the fill deal with down to see the different consequence.
- There are two different strategies to use the LOG10 function.
- Technique one is to click on the fx button on the high left of the Excel worksheet.
- An Insert Function dialog field will seem.
Inside the dialog field, in the part Choose a Class, choose Math and Trigonometry from the listing field.
In the part Choose a Function, select the LOG10 function from the listing.
Then click on OK.
A Function Arguments dialog field will open.
Kind into the entry packing containers the cell that incorporates the quantity you need to calculate.
Then click on OK.
Technique two is to click on the Formulation tab and click on the Math and Trigonometry button in the Function Library group.
Then choose LOG10 from the drop-down menu.
A Function Arguments dialog field will open.
Comply with the identical technique in Technique 1.
Then click on OK.
We hope you perceive how to use the LOG and LOG10 features in Microsoft Excel.
What’s the distinction between LOG and LOG10 in Excel?
The distinction between the LOG and LOG10 features in Microsoft Excel is that LOG returns the logarithm of a quantity to the base you specify, and LOG10 returns the base -10 logarithm of a quantity. In different phrases, you may specify the quantity whereas utilizing LOG function. On the different hand, the base is mounted in LOG10 function.
What’s the distinction between log and LN in Excel?
The distinction between the LOG and LN features in Excel is that LOG returns the logarithm of a quantity to the base you specify, whereas the LN function returns the pure logarithm of a quantity. Log and LN are the identical phrases which are getting used in Arithmetic in college or school books.
READ: How to use the MINVERSE and MMULT features in Excel
READ: Prime 15 Monetary features in Microsoft Excel.
