Convert IC50 values to pIC50 values

Prev Next

Converting values between units is currently addressed through creating new calculated columns.

In your dataset page, on the bottom left corner, you can find the Formula button:
image.png

Click on it. You'll enter a form where you need to provide the formula to be used.
For the example below, we have an IC50 column expressed in nanomolar which we want to transform in pIC50. To do so, proceed as follows:

  • We first need to enter a name for the new column. It must be unique - there is currently no way to override an existing column.
    image.png

  • Next the formula. Start entering "-log(". Then, you can start typing the column name. Autocomplete will suggest you the list of column matching, you can then click on the column to convert and then finish by closing the parenthesis. You should end with something like this:

image.png

  • Click on Create. Your calculated column has been added to your dataset, and you can use it as any other columns.

As a reminder, until we introduce pre-defined conversion functions, here are a bunch of formulas that might be useful for unit conversion when using IC50s.

IC50 to pIC50

pIC50 = -log10(IC50_M)
pIC50 = -log10(IC50_mM * 1e-3)
pIC50 = -log10(IC50_uM * 1e-6)
pIC50 = -log10(IC50_nM * 1e-9)