Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() |
#2
![]() |
|||
|
|||
![]()
First you need to tell us what IC50 is.
-- Regards, Fred "jc33" wrote in message ... |
#3
![]() |
|||
|
|||
![]()
Create a simple table of two columns. The first column could be the
concentration in the desired units i.e. micrograms per litre. The second column could be the inhibitory effect from 0% to 100%. Then you can use VLOOKUP() to find the approximate 50% level. -- Gary''s Student "Fred Smith" wrote: First you need to tell us what IC50 is. -- Regards, Fred "jc33" wrote in message ... |
#4
![]() |
|||
|
|||
![]()
Can you please define each paramater that needs to be entered?
lookup_value table_array col_index_num range_lookup "Gary''s Student" wrote: Create a simple table of two columns. The first column could be the concentration in the desired units i.e. micrograms per litre. The second column could be the inhibitory effect from 0% to 100%. Then you can use VLOOKUP() to find the approximate 50% level. -- Gary''s Student "Fred Smith" wrote: First you need to tell us what IC50 is. -- Regards, Fred "jc33" wrote in message ... |
#5
![]() |
|||
|
|||
![]()
You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html It might help with the questions caused by excel's help for =vlookup(). jc33 wrote: Can you please define each paramater that needs to be entered? lookup_value table_array col_index_num range_lookup "Gary''s Student" wrote: Create a simple table of two columns. The first column could be the concentration in the desired units i.e. micrograms per litre. The second column could be the inhibitory effect from 0% to 100%. Then you can use VLOOKUP() to find the approximate 50% level. -- Gary''s Student "Fred Smith" wrote: First you need to tell us what IC50 is. -- Regards, Fred "jc33" wrote in message ... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calcuate bond yields | Excel Worksheet Functions | |||
how to analyze freight expense? | Excel Worksheet Functions | |||
How do I analyze data from a survey in excel | Excel Worksheet Functions | |||
calcuate sales by date and segments | Excel Worksheet Functions | |||
Using Excel to analyze HTML | Excel Discussion (Misc queries) |