Column/value type issue with formula
I am trying to get some data that we currently store in Excel into JMP. In Excel, we use a VLOOKUP function (the 'HIV alert limits' column correlated to the 'semester donations estimate' column) and then calculate the '% of standard' column (HIV total/HIV alert limits) to get a percent. In JMP, I have made the 'HIV alert limits' column with an IF formula. This formula works on a range and based ...