Question

Define the following function with example
a) Count A Function
b) MAX A function
c) IF function​

Answer 1

Answer:

(1) COUNTA function to count cells that contain numbers, text, logical values, error values, and empty text (""). For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5

(2) MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value. [sorry I don't know any example]

(3) IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. For example: =IF(A2>B2,"Over Budget","OK")