Use of Excel Spreadsheets to Create Interpretive Reports for Laboratory ...
To illustrate the complexity of the formulas and the skill required with Excel mathematics and Boolean logic functions, the formula used to calculate the IgG SR and provide the interpretation of the pattern of results for all 4 indices, in the order shown in Table 1 is demonstrated below. For the CSF and serum IgG and albumin data shown in Figure 1, the pattern of results is A, N, A, A, where ...