Forum Discussion
StephenDC
Mar 12, 2020Copper Contributor
Need formula,command or IF statement
I keep my lab results in a worksheet and I am looking for a way for the worksheet to flag Hi and LO results. I am not that familiar with Excel work sheets but if I could find a formula, IF statement...
Charla74
Mar 13, 2020Iron Contributor
Maybe something like attached? The formula assumes less than or equal to lower tolerance and more than or equal to higher: