Category: Excel Functions

Lookup data in single row or column with Excel Lookup function

Excel Lookup function   With Lookup function, you need to look in a single row or column and find a value from the same position in a second row or column.   Looking up data...

Row lookup using HLOOKUP function in Excel

Excel HLOOKUP function   HLOOKUP stands for Horizontal lookup. It looks for a value horizontally, i.e, in a row.   HLOOKUP helps in looking up data in a row across the top of the...

Error Handling using IFERROR function in Excel

Excel IFERROR function   IFERROR function is used to captures and handles errors occurred while executing a formula.   IFERROR function returns specified value if the formula results in an error, otherwise it returns...

Rounding number to the nearest multiple using MROUND in Excel

Excel MROUND function   MROUND function rounds a number to the nearest multiple of the specified number.   Example :   MROUND(10,3)   Nearest multiple of 3 to 10 is 3*3 = 9.  ...

Excel AVERAGEA function

AVERAGEA function in Excel   AVERAGEA function in Excel returns the average(Arithmetic Mean) of its arguments.   It considers Text and FALSE(boolean) as 0.   It considers TRUE(boolean) as 1.   Formula   =AVERAGEA(value1,...