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 in multiple rows/columns using LOOKUP is discouraged, the VLOOKUP function should be preferred instead. So, use this for 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 table. It searches for a value in the top row of a table or an array of values, and then […]
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 the result of the formula. So, it works as a error handling step for your formula.. it shows a user […]
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. So, MROUND(10,3) = 9 Formula =MROUND(number, multiple) The MROUND function syntax has the following arguments: number is […]
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, [value2], …) Here, value1, value2, … are the values on which average will be calculated. Atleast one value is […]