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...
Category: Excel Functions
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,...