Reporting "<" values in ChemStation
Posted: Thu May 25, 2017 6:22 pm
With an intelligent report, is there a way to add conditional formatting field so that any values below calibration report as "<LOQ" or a similar text?
You need to create an IF statement in the value field
=iif(compound_concentration<value,"<LOQ",compound_concentration)
Of course you can replace Copmpound_concentration by Compound_Amount or Area or whatsoever.
iif is not a typo! it has to be that way