Posts

IF Formula in Excel

-
Image
 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.
Post a Comment
Read more

Excel TRIM Formula

-
Image
 TRIM Formula   This formula is used to remove unnecessary space in a cell or Text. Example =TRIM(A1) Cell A1 has unnecessary space between Ram__Kumar __Gupta, so it removes unnecessary space and give RESULT = Ram_Kumar_Gupta.
Post a Comment
Read more

Excel LEN Formula

-
Image
 LEN Formula  This formula is used to calculate the number of character in a cell or Text. Example =LEN(A1) Result - 6 Cell A1 value is Shivam which has 6 Character length.
Post a Comment
Read more

Excel MAX Formula

-
Image
 MAX Formula  This formula is used to get the maximum value in cells or Range. Example =MAX(A1:A5) Result = 9 (See below)
Post a Comment
Read more

MIN Formula in Excel

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

AVERAGE in Excel

-
Image
 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)
Post a Comment
Read more

COUNTBLANK in Excel

-
Image
 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
Post a Comment
Read more