By W3era
Adds up all the numbers in a range.
Calculates the average of a group of numbers.
Searches for a value in the first column of a table range and returns a value in the same row from a specified column.
Returns one value if a condition is true and another value if it's false.
Counts the number of cells that meet a criterion.
Joins two or more text strings into one string.
Returns the serial number of a particular date.
Calculates the payment for a loan based on constant payments and a constant interest rate.
Returns the largest and smallest numbers in a set, respectively.
Used together, these can look up and return a value from a specific place in a table.
www.w3era.com +91-7073197281