Displays the value in cell A2 if itâs less than A3 AND less than 100, otherwise it displays the message The value is out of range. =IF(AND(A3>1,A3<100),A3,The value is out of range) Displays the value in cell A3 if it is greater than 1 AND less than 100, otherwise it displays a message.
A gamma globulin test is used to test the amount of immunoglobins in the blood. Immunoglobins are also called immune gamma globulins. Immunoglobins are antibodies that are produced by the body in response to foreign substances such as bacteria, viruses, and cancerous cells.
The human chorionic gonadotropin (hCG) test is done to check for the hormone hCG in blood or urine. Some hCG tests measure the exact amount and some just check to see if the hormone is present. HCG is made by the placenta during pregnancy.he level of hCG in the blood is often used as part of a screening for birth defects in a maternal serum triple or quadruple screening test. Generally done between 15 and 20 weeks, these tests check the levels of three or four substances in a pregnant woman's blood.