Example:

In this example, we first use the CELL function’s first parameter “col” to calculate the column number of cell E20. Second, we use “row” as the first argument to calculate the row number of cell A25. Third, we use the first parameter “contents” to find the contents of cell A3, which is “Good Morning.” Fourth, we determine the kind of cell content by utilising the first argument, “type,” which is the data type value, which is v.

We use the first parameter as “format” in the fifth and sixth parameters to determine the format of the cell contents mentioned in the second parameter. Fifth, we obtain the letter G because the cell content in A4 is in General format, thus we get the letter G. Similarly, the content of A5 is represented as a number, so the solution will be F2.