Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down then populate | Excel Discussion (Misc queries) | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions |