calculation LOG10 using relationals

N

naflan

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
 
M

Marcelo

try

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

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

"naflan" escreveu:
 
M

Marcelo

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:
 
N

naflan

"I must confess that I also do not understand the OP's <10 in naflan's
formula."
Sandy,
In microbiology, if the number of colony forming units (CFU) recovered from
a sample prep. diluted 1:10 is zero, it is reported <10 because of the
dilution factor. So the log reduction should be >5.0

naflan
 
Top