• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
EngineerExcel

EngineerExcel

FREE EBOOK
  • About
  • Course
  • Free Training
  • Resources
  • Login

LN, LOG, LOG10, EXP, SQRT, and FACT Functions in Excel

Excel features many of the common mathematical functions that you’ll encounter in engineering: logarithms, exponentials, square roots and factorials.

This section covers three example problems that use these functions. Worksheet 03f is set up to calculate true strain from engineering strain data collected on a tensile test machine. The equation for true strain is:

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

where is the engineering strain found in column B. Select the first cell in the true strain column and enter the formula =LN(1+B5). Press Enter, select that cell
and double-click the fill handle to apply the formula to the rest of the column. This will allow you to see how the true stress and strain compare to the engineering stress and strain.

Logarithms come up often when dealing with sound measurements. For instance, a logarithm is used to calculate the overall sound pressure from sound measurements at individual frequencies. In Worksheet 03g, the A-weighted sound pressure level can be calculated from measured sound levels using the equation:

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

First, you’ll have to calculate from the corrected sound value, Li, in column E. Enter =10^(E4/10) in the first cell of column F. Select the first cell and double-click the fill handle. Next, we’ll calculate L using the SUM function to get the sum of the values in column F. In the large cell next to “Sound Pressure,” enter =10*LOG(SUM(F4:F11)). The LOG function assumes base ten unless you specify the base in a second argument, i.e. LOG(8,2) will find .

Worksheet 03h contains an example using the exponential function. This function is used often for decaying oscillations. The ratio of successive oscillation amplitudes can be calculated if the damping ratio is known using the formula:

where x1 is the first oscillation amplitude, x2 is the second oscillation amplitude, and δ is the damping ratio. Worksheet 03h contains the first oscillation amplitude in cell C4 and the damping ratio in cell C5, so we can rearrange the equation to solve for the second oscillation amplitude. In the cell next to “Second Oscillation Amplitude,” enter =C4/EXP((2*PI()*C5)/SQRT(1-C5^2)).

Note that we’ve used three Excel functions here: EXP for the exponential, PI() for the value of π, and SQRT for the square root. Enclosing the exponent’s numerator and denominator in parentheses helps ensure Excel reads our formula correctly – this is a good habit to adopt.

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

Primary Sidebar

Featured Posts

How to Enable the Excel Solver Add-In

Combine UDF’s and Named Cells to Boost Efficiency in Excel

3 Ways to Update a Scatter Chart in Excel

Using Excel Data Validation to Avoid Errors

How Excel Logical Functions are Used to Clean Up Data Tables

About Me: Charlie Young, P.E.

I’m a licensed professional engineer with a degree in Mechanical Engineering and over a decade of practical experience building engineering applications in Excel. My goal is to help you learn how to turn Excel into a powerful engineering tool.

If you’re interested in learning more, click the button below to receive an update whenever I have a new tip to share. I’ll also send you a copy of my free eBook “10 Smarter Ways to Use Excel for Engineering”.


Subscribe Now

Footer

SOCIAL

Keep up with EngineerExcel:
  • Email
  • RSS
  • YouTube
EngineerExcel

Free Course

Navigation

  • Home
  • About
  • Free Course
  • Excel Tips
  • Resources
  • Coupon
  • Login

Support

  • Support
  • Terms
  • Privacy

Copyright © 2021 EngineerExcel.com · Log in