try

LOG10(1.0E+06)-LOG10(MAX(10))

Hope it helps, thanks for the feedback
Regards from Brazil
Marcelo

"naflan" escreveu:

Correction:
LOG10(1.0E+06)-LOG10(<10)

"naflan" wrote:

How would I go about calculating this:
LOG101.0E+06)-LOG10(<10) ?

excel does not let me use <10 in the calculation.

The answer needs to be 5.0