Array formulas allow you to use multiple cell inputs rather than a single cell input. There are two types of array formulas. One type of array formula returns a single value from multiple inputs. A common example is the SUM function: The other type of array formula is one that returns multiple outputs. A simple… Read more about Array Formulas in Excel for Engineering Calculations
There are additional logical functions that you can use along with the IF function to add even more logical decision-making capability. First, the AND function can be used to check if multiple conditions are true. Its syntax is: AND(logical1, [logical2], [logical3] … ) logical1: condition to be tested logical2, logical3, etc.: (optional) additional condition to… Read more about AND and OR Functions in Excel
Inevitably, you will often reference other cells in your calculations. There are two different types of cell references in Excel: relative and absolute. This is an important concept to understand for entering formulas in Excel. Relative cell references will change when a formula is copied to another cell. Absolute cell references will remain constant when… Read more about Absolute and Relative Cell References in Engineering Spreadsheets
You can use Excel to fit simple or even complex equations to data with just a few steps. Determine the Form of the Equation The first step in fitting an equation to data is to determine what form the equation should have. Sometimes this is easy, but other times it will be more difficult. Usually,… Read more about How to Fit an Equation to Data in Excel
In a recent post, I showed how you can multiply matrices in Excel. That post led to a great question from an EngineerExcel subscriber: Is there a way to do complex matrix multiplication in Excel? The answer is yes, there is! Complex Numbers in Excel Complex numbers are stored in Excel cells as text strings,… Read more about Complex Matrix Multiplication in Excel
Since a worksheet is essentially a gigantic matrix, it’s no surprise that matrix multiplication in Excel is super easy. Matrix Multiplication in Excel with the MMULT function You can multiply matrices in Excel thanks to the MMULT function. This array function returns the product of two matrices entered in a worksheet. The syntax for the… Read more about Matrix Multiplication in Excel
Of all the constants in Science, Engineering, and Mathematics, pi, or the ratio between a circle’s circumference and diameter is by far the most common. (Ok, I just made that up, but it seems about right.) Not surprisingly, then, it ends up in a ton of Excel calculations. Below, I’ve put together a comprehensive guide… Read more about Pi in Excel
Array formulas in Excel are a great tool for performing time-series calculations or sensitivity studies on input variables. An array is a group of cells that can be treated as one entity. There are two types of arrays: one-dimensional (values in rows OR columns) or two-dimensional (values in rows AND columns). An array formula is… Read more about 3 Steps to Working with Array Formulas in Excel
In the last blog post, I showed how to use VBA to create a vector plot in Excel. That plot was just a simple black and white vector plot. So in this post I’ll show you how to take that chart to the next level with a color scale to indicate the magnitude of the… Read more about Colored Vector Plot in Excel
Read Full Article
Read for later
Articles marked as Favorite are saved for later viewing.
Scroll to Top
Separate tags by commas
To access this feature, please upgrade your account.