- Formula
- L_T = 10·log₁₀( 10^(L₁/10) − 10^(L₂/10) )
- Output
- dB
- Bands
- Two levels
- Standard / Source
- General acoustics (no standard cited)
- Access
- Inline =function
What it does
Removes one level from another on an energy basis — for example, subtracting a measured background level from a total to recover the source contribution. It is only valid when the first level exceeds the second; otherwise it returns 0.
Equation
How to use it
=DBSUB(L1, L2)
=DBSUB(85, 80)Worked example
=DBSUB(85, 80) → 83.3 dB
(Removing an 80 dB component from an 85 dB total leaves 83.3 dB — close to the total, because the subtracted part is comparatively small.)
ℹ️ If the background is within ~3 dB of the total the result becomes unreliable, and if it meets or exceeds the total the function returns 0.
Source
Standard energy subtraction of levels. No specific published standard is cited in the software.