calculating a 2-log drop
 

Hey all, quick formula question:
For explanatory purposes, Ive got a number in Cell A1 that is a
patient's baseline viral load, and in Cell B1 I've got the patients
viral load at 12wks of treatment. I am having trouble figuring out how
to write a formula that in another cell will determine whether this
patient shows a 2-log drop response between his baseline and 12wk
marker points.

My shortcut for 2 log drops is just moving the decimal place two digits
to the left, hence a baseline load of 2,800,000 after a 2-log drop would
be 28,000, and if the patients 12wk load was less than this, they could
be deemed an Early Viral Responder in an adjacent cell.... without me
having to perform this calculation for the 3,000 patients in my
database.

Any help would be appreciated, thank you!
-Sean


--
SMutchnick
------------------------------------------------------------------------
SMutchnick's Profile: http://www.excelforum.com/member.php...o&userid=35019
View this thread: http://www.excelforum.com/showthread...hreadid=561190

calculating a 2-log drop
 

In C1: =IF(B1<A1/100,"Early Responder","")

Then fill the formula down the column.

--
Carlos

"SMutchnick" wrote
in message ...

Hey all, quick formula question:
For explanatory purposes, Ive got a number in Cell A1 that is a
patient's baseline viral load, and in Cell B1 I've got the patients
viral load at 12wks of treatment. I am having trouble figuring out how
to write a formula that in another cell will determine whether this
patient shows a 2-log drop response between his baseline and 12wk
marker points.

My shortcut for 2 log drops is just moving the decimal place two digits
to the left, hence a baseline load of 2,800,000 after a 2-log drop would
be 28,000, and if the patients 12wk load was less than this, they could
be deemed an Early Viral Responder in an adjacent cell.... without me
having to perform this calculation for the 3,000 patients in my
database.

Any help would be appreciated, thank you!
-Sean


--
SMutchnick
------------------------------------------------------------------------
SMutchnick's Profile:
http://www.excelforum.com/member.php...o&userid=35019
View this thread: http://www.excelforum.com/showthread...hreadid=561190

calculating a 2-log drop
 

haha, thank you! I was just realizing i could cheat like that and ditch
any log functions!

-Sean


--
SMutchnick
------------------------------------------------------------------------
SMutchnick's Profile: http://www.excelforum.com/member.php...o&userid=35019
View this thread: http://www.excelforum.com/showthread...hreadid=561190