I have the following predictor formula in a column
VMax / (1 + (K / :Dilution) ^ Slope)
where Vmax, K and Slope are all parameters.
This formula describes a biological assay where Vmax cannot be greater than 100% (both mathematically and biologically). I would like to constrain the range for Vmax between 0 and 100 to ensure K and Slope are accurate. Any help would be fantastic.
There may be a different way to do this, but I think you can put the constraint into your predictor formula.
If( Vmax > 1, Vmax = 1, Vmax ) / (1 + (K / :Dilution) ^ Slope)