Haha, awesome :)
Do you remember any of it? I’d like to know how to make my function check whether the input is non-numeric, the issue being that the lab data it’s working with will sometimes have gaps in it, so the input cell might be blank or say ND (non-detectable) or something like <0.001 (less than the lowest amount the lab can measure). Right now I’ve settled for making the cell only accept numbers, but that will be a pain in the ass for entering the lab data because it won’t let you paste it in if it happens to be non-numeric. So, e.g. I have =COPPER(A1) and cell A1 is restricted to numeric data only, but I’d prefer that the COPPER function be able to check and return an appropriate value if A1 has something that isn’t a number or if it’s blank.
…I’m not a programmer. I know just enough to get myself in trouble. :P