A reference sample has 50 particles and a test sample of the same volume has 5,000. Express that difference as a power of ten so the direction and magnitude are easy to read.
Divide test by reference before taking the logarithm
Put 50 in B2 and 5000 in C2. In D2 enter:
=LOG10(C2/B2)The ratio is 100, and 100 is ten squared. D2 should show 2.

Illustrated calculation. Compare readings on the same unit and sample basis.
Swap the inputs and test equal readings
The reverse ratio is 0.01, so the answer becomes −2. Set both readings to 50 and expect 0. Label the result “log₁₀(test/reference).” Flag zero or missing readings separately, and compare rates first if the samples use different volumes.

Illustrated direction check. Keep the numerator named in the column heading.



