Hi Sandy just to subst the "<" sinal...
After my answer I try it on excel and see the same of you..

Regards
Marcelo

"Sandy Mann" escreveu:

Marcelo" wrote in message
...

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

Marcelo,

May I ask whay the purpose of the MAX() function is?

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

returns 5 as well.

I must confess that I also do not understand the OP's <10 in naflan's
formula.


--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Marcelo" wrote in message
...
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