Excel Help sheet

 IF Formula   IF function is Logical function which is used to perform a logical test. Example =IF(A1>33,”P”,”F”)  Result - P The value of Cell A1 is 50 which is greater than 33. The logical test is, IF the value is greater than 33 then result would be P else the result would be F. So the result is P.

 MAX Formula  This formula is used to get the maximum value in cells or Range. Example =MAX(A1:A5) Result = 9 (See below)

 MIN Formula  This formula is used to get the minimum value in cells or Range. Example =MIN(A1:A5) Result = 2 (See Image Below)

 AVERAGE Formula  This basic formula in excel is used to get the average of the value in one or more cells or range. Example - 1 =AVERAGE(A1:A5)   Result = 4 (See Image below)

 COUNTBLANK formula  COUNTBLANK function is used to count blank values in the range. (Note: Only Space in a cell will not be considered as a blank cell). Example - 1 =COUNTBLANK(A1:A5) Result = 2  This will calculate the number of blank cell in Range. See Image below

COUNT in Excel It is used to Count the numeric value in one or more cells or range. Example - 1 =COUNT(A1:A5) Answer = 4, Because this formula only count numeric value it exclude A3 cell.

Sum Formula This Basic Excel Formula is used to get the sum of the value in one or more cells or range Example - 1 =SUM(A1:A5) Answer is - 41 Example - 2 =SUM(1, 3,5,9) Answer is - 18