Things to Remember:
– If a single cell reference is given instead of cell range/array in array argument, then function output will be 1
– If cell reference is not correctly provided in the function, then it will give output as an error.
– Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”