The Formula Gym
XP 0
Streak 0

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

SUMBeginner

Add up a column or range of numbers

FinanceSales & OpsHREngineering
6 lessons · 1 freeLearn it
AVERAGEBeginner

Find the typical value in a set of numbers

FinanceSales & OpsHREngineering
6 lessons · 1 freeLearn it
MAX / MINBeginner

Find the highest or lowest value fast

Sales & OpsFinanceEngineering
5 lessons · 1 freeLearn it
COUNTBeginner

Count how many cells contain numbers

Data cleanupHREngineering
5 lessons · 1 freeLearn it
COUNTIFIntermediate

Count rows that meet a condition

Sales & OpsHRData cleanupEngineering
6 lessons · 1 freeLearn it
SUMIFIntermediate

Add up only the rows that meet a condition

FinanceSales & OpsEngineering
5 lessons · 1 freeLearn it
COUNTIFSIntermediate

Count rows that meet several conditions

HRSales & OpsData cleanupEngineering
5 lessons · 1 freeLearn it
SUMIFSIntermediate

Add up rows that meet several conditions

FinanceSales & OpsEngineering
6 lessons · 1 freeLearn it
IFIntermediate

Show one result or another based on a test

FinanceHRSales & OpsEngineering
6 lessons · 1 freeLearn it
Nested IFIntermediate

Choose between three or more outcomes

FinanceHRSales & OpsEngineering
5 lessons · 1 freeLearn it
AND / ORIntermediate

Combine several tests inside IF

FinanceHRSales & OpsEngineering
5 lessons · 1 freeLearn it
ROUNDIntermediate

Tidy numbers to a set number of decimals

FinanceEngineering
5 lessons · 1 freeLearn it
VLOOKUPIntermediate

Find a value in a table by its ID

Sales & OpsFinanceHREngineering
6 lessons · 1 freeLearn it
INDEX / MATCHAdvanced

Look things up in any direction

FinanceSales & OpsEngineering
5 lessons · 1 freeLearn it
IFERRORIntermediate

Replace errors with something readable

Data cleanupFinanceEngineering
5 lessons · 1 freeLearn it
NPVAdvanced

Value future cash flows today

FinanceEngineering
5 lessons · 1 freeLearn it

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.

See membership