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.
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)
Comments
Post a Comment