Hello,
I am having trouble with this nested IIF statement. I understand there is a lot going on with this, but IIF :) I can get this last condition, I will be all set.
=IIf([Primary Result 1]="ND","",IIf(Val([Primary Result 1])>=[MCL1],"O",""))
This portion works fine.
I want to nest...