calculation LOG10 using relationals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
try

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

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

"naflan" escreveu:
 
LOG10(1.0E+06)-LOG10(MAX(10))
Click to expand...

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
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:
 
"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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

back transforming log10 standard error 1
How to calculate an inverse of log base 10 1
log functions - inverse? 1
backtransforming log10 SE 3
3 most significant digits 4
Scrabble Value calculation for Welsh words 0
Calculator in C# 1
Help simulating PRODUCT() in MS Access SQL query 2

Back
Top