Like most of the functions you are familiar with in Excel, the IF function delivers an output to a single cell, as opposed to a range of cells (as would be the case for an array function). In using it to process multiple entries throughout a spreadsheet, you construct it for a single cell and then copy it down to additional cells in a range.
AST (SGOT) Test. This blood test measures an enzyme called aspartate aminotransferase (AST). Enzymes are chemicals that help the cells of your body work. AST is found in red blood cells, liver cells, and muscle cells, including the heart. It is released into the blood when these cells are damaged.
When a doctor draws blood to complete an ALT and AST test, they typically look for indicators that something is malfunctioning within the body. Most doctors complete these two tests at the same time because they offer a better ratio for comparison.