Skip to content
ContentsExcel-Style Cell FormulaeUser guide

Excel-Style Cell Formulae

Besides the calculation blocks you insert from the ribbon, any cell will take a formula you type yourself, the same way Excel does. Start with =, press Enter, and the cell shows the result and recalculates whenever its inputs change.

This page covers the functions available when you type into a cell. It is a different thing from the Formula Reference, which documents the acoustic calculations the ribbon inserts as row-blocks.


Timbral's own acoustic functions

These are specific to Timbral and are the ones worth knowing. All of them accept a range (C5:H5) or a list of values.

Level arithmetic

FunctionWhat it doesExample
DBADDLogarithmic (energy) sum of levels=DBADD(C5:H5)
DBSUBLogarithmic subtraction of one level from another=DBSUB(85, 80)
DBAVGEnergy-average of levels=DBAVG(C5:H5)
SOURCECOUNTCORRECTIONCorrection for n identical incoherent sources, i.e. 10·log₁₀(n). Add it to a single source's level.=SOURCECOUNTCORRECTION(4) → 6.02
RMSRoot mean square of a signal sampled down a column=RMS(C5:C40)
BGCORRECTISO 16283-1 Formula 14 background-noise correction, given the measured and background levels=BGCORRECT(60, 52)

The background correction follows the standard's three cases: a margin of 10 dB or more takes no correction, 6 dB or less takes the fixed −1.3 dB penalty, and anything between is a straight energy subtraction.

Single-figure ratings

FunctionRating
NRRATINGNoise Rating
GRATINGG (vibration) rating
DBAA-weighted overall level
DBB, DBC, DBD, DBR, DBHThe corresponding weighted overall levels
DBZZ-weighted (unweighted) overall level — the plain logarithmic sum, same maths as DBADD
SRIRATINGWeighted sound reduction index, ISO 717-1 — Rw with its C and Ctr terms by default (e.g. 55 (-2; -7)); pass a variant code ("rw", "rw-c", "rw-ctr", "dw", "dw-c", "dnt-w", ...) as a trailing argument for a single figure or the Dw/DnT,w families, and a reverberation time in seconds after a "dnt-w*" code (default 0.5 s if omitted)
ABSORPTIONWEIGHTING, ABSORPTIONCLASSWeighted absorption coefficient and its class, ISO 11654

These are the same functions the Rating column writes for you when you switch it on, so a rating cell and a typed formula always agree.

The weighted levels (DBA–DBH, DBZ) show one decimal place by default. A trailing "dp:N" argument sets the number of decimal places, from 0 to 10: =DBA(C5:K5, "dp:2"). The ribbon's decimal-place buttons write this argument for you on a Rating cell.

Two shapes of the same conversion:

  • Whole-spectrum — SUMTHIRDTOOCTAVE, SRITHIRDTOOCTAVE, ABSORPTIONTHIRDTOOCTAVE take a one-third-octave range and return a single aggregate number.
  • Per-band — SUMTHIRDOCTAVE, SRITHIRDOCTAVE, ABSORPTIONTHIRDOCTAVE take the range plus the octave band you want, so each octave cell can reference the one-third-octave row and update live: =SUMTHIRDOCTAVE(C5:AC5, 63).

Standard Excel functions

Around 440 Excel functions are available. The families below are verified against Excel's own answers on every build. A function name Timbral does not support gives #NAME?, as in Excel, and the formula text stays in the cell so you can correct it.

Lookups

VLOOKUP, HLOOKUP, MATCH, INDEX, LOOKUP and XLOOKUP all behave as they do in Excel, including the INDEX/MATCH idiom:

=VLOOKUP("Orange", A2:B5, 2, FALSE)
=INDEX(C1:C5, MATCH(3, A1:A5, 0))
=XLOOKUP(99, A1:A5, C1:C5, "not found")

Worth knowing:

  • Text matching ignores case, as in Excel — "beta" finds Beta.
  • A miss is #N/A, never a blank cell.
  • A column index past the table is #REF!; below 1 it is #VALUE!.
  • Wildcards work on exact-match lookups: ? for one character, * for any run.

Conditional counting and summing

COUNTIF, SUMIF, AVERAGEIF and their …IFS forms take the usual criteria language:

=COUNTIF(A1:A5, ">2")
=SUMIF(D1:D5, "x", C1:C5)
=SUMIFS(C1:C5, D1:D5, "x", A1:A5, ">1")
=COUNTIF(D1:D5, "<>x")

Everything else in common use

Aggregation (SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, MEDIAN, SMALL, LARGE, RANK), logic (IF, AND, OR, NOT, IFERROR, ISNA), text (UPPER, LEFT, LEN, CONCATENATE, TEXTJOIN, TRIM) and dates (DATE, YEAR) all behave as expected.


Numbers and how they display

Results are shown to 15 significant digits, which is Excel's own display precision. This is why =1.2+1.5+2.1 reads 4.8 rather than 4.800000000000001.

The full-precision value is what gets used downstream, so — exactly as in Excel — a comparison like =F1=0.3 can be FALSE while F1 plainly reads 0.3.

TRUE and FALSE display in capitals so that copying a cell into Excel gives you a real boolean rather than text.


Known limitations

These are real and current.

  • Array formulae do not spill — TRANSPOSE, SORT and UNIQUE have nowhere to write their extra cells, and FILTER is not available.
  • SUBTOTAL is not available and gives #NAME?. Use SUM, or AGGREGATE (e.g. =AGGREGATE(9,6,C1:C5)) — but note AGGREGATE cannot see hidden rows, so its "ignore hidden rows" options still count every row. Its "ignore errors" options work.
  • A few specialist functions are deliberately unavailable and give #NAME?: the bond and coupon finance functions (PRICE, YIELD, DURATION, COUPNUM and relatives), XIRR, VDB, the F and beta distributions (FDIST, FINV, FTEST, BETADIST, ...), and INFO, SHEET, SHEETS, ISFORMULA.
  • Only the common dotted names work. NORM.DIST, STDEV.P/.S, VAR.P/.S, QUARTILE.INC, PERCENTILE.INC, T.DIST, T.TEST, CONFIDENCE.NORM and similar are available; a dotted name outside that list gives #NAME? — try its undotted form (STDEV, QUARTILE).
  • + with ordinary text joins the text instead of giving #VALUE!: if A1 holds Lmax event, =A1+1 shows Lmax event1. A rating label is the exception — arithmetic on a cell reading 73.2 dB(A) or NR 35 uses its number.

A note on the sign convention

Attenuation and sound reduction are stored as negative dB throughout Timbral, so a path is summed by adding its terms. Keep that in mind when writing your own arithmetic: a 40 dB partition contributes −40, not 40.

Register interest

Tell us a little about you and we'll be in touch when Timbral is ready.