It must be typed into the target cell.
Enter the example data, as shown, into a blank Excel worksheet.
Select cellF8, which is where the function results will display.
The complete function appears in theformula barabove theworksheetwhen you select cell F8.
