Hi. I'm trying to determine if a lab result fits within the target range. Ex: We want the patient's labs to be within 2.0-3.0 with her lab results being 2.5,2.3, 3.8, 1.7, 2.9 etc in column G4:G4567. I would like the formula to tell me if the lab result is low (lower than the desired range), high (higher than the desired range) or in range. Different formulas I've tried are:

=IF($G4<2,"low",IF($G4>3,"high","in range"))

=COUNTIF($G4,"<2.0")

I tried a VLOOKUP with a table that looks like:

1.9 Low
2.0 In Range
3.1 High

=VLOOKUP(G4,$AE$3:$AF$5,2,TRUE)

And nothing is working. "lows" are returned when it should be "high" or "in range" or I get an #NA or 0's.

Is there a quick way to determine the lab value is in range or out of range (upper/lower)?

Thanks!