Need formula,command or IF statement

Question

I keep my lab results in a worksheet and I am looking for a way for the worksheet to flag Hi and LO results.&nbsp; I am not that familiar with Excel work sheets but if I could find a formula, IF statement AND OR command it would help to greater keep track of&nbsp; annual lab results.&nbsp; The basic format is:and continues down the work page until all the analytes for the test are entered.DATE&nbsp; &nbsp; &nbsp;&nbsp; TEST &nbsp; RESULT&nbsp; REFERENCE&nbsp;&nbsp; FLAG1/30/20&nbsp;&nbsp;&nbsp; Wbc&nbsp;&nbsp;&nbsp; 9.9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.3-9.9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this is where I want "H or L""&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rbc&nbsp;&nbsp;&nbsp;&nbsp; 3.8&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; 3.8-5.9Thanks if anyone can help answer this question.StephenDC

charla74 · Answer

StephenDC&nbsp;&nbsp;Maybe something like attached?&nbsp; The formula assumes less than or equal to lower tolerance and more than or equal to higher:&nbsp;&nbsp;

subodh_tiwari_sktneer · Answer

StephenDC&nbsp;Please upload a sample file with some dummy data and the desired output mocked up manually along with the criteria for Low, High or Normal flag.

mtarler · Answer

StephenDC&nbsp; this also sounds like a perfect application for Conditional Formatting.&nbsp; Conditional Formatting won't insert a value like 'Hi' or 'Lo' but can/will highlight cells.&nbsp; If you need to export the sheet or use those 'flags' in other references then conditional formatting won't work, but if it is just for you to quickly see or find those values, conditional formatting is the way to go.

Forum Discussion

Need formula,command or IF statement

3 Replies