Excel functions for engineering
Engineering spreadsheets are mostly readings, tolerances and test results. You need to total them, find the extremes, flag anything out of limits and look up part details. These functions cover it.
Typical jobs
- Average a run of sensor readings
- Find the peak load or the weakest result
- Flag readings that are outside tolerance
- Count failures by line or batch
- Look up a part's rating from its part number
16 functions to learn
Add up a column or range of numbers
Find the typical value in a set of numbers
Find the highest or lowest value fast
Count how many cells contain numbers
Count rows that meet a condition
Add up only the rows that meet a condition
Count rows that meet several conditions
Add up rows that meet several conditions
Show one result or another based on a test
Choose between three or more outcomes
Combine several tests inside IF
Tidy numbers to a set number of decimals
Find a value in a table by its ID
Look things up in any direction
Replace errors with something readable
Value future cash flows today
Other jobs
Unlock every lesson
Every function has a free lesson. Members get all the lessons, fresh exercises every time and the weekly leaderboard. £7 a month or £49 a year, and you can cancel at any time.