Introduction ODD function in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to the nearest odd integer. For example, number 2 is rounded up to the nearest odd integer by using the formula =ODD(2) which gives 3 as the result. It can also be used to find … Read more
Introduction ROUNDUP function in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to a defined number of decimal places. For example, number 1.5 is rounded up to 0 decimal places by formula =ROUNDUP(1.5,0) which gives 2 as the result. ROUNDUP function is same as MROUND function except … Read more
Introduction SWITCH comes in the category of logical functions. SWITCH function can be used for logical comparison of an expression to a list of values and to get the corresponding result. This can do multiple tests in a single run. Difference between SWITCH and IFS function is that SWITCH function evaluates only an exact match … Read more
Wish you very happy new year 2019. May the New Year bring you delight, health and happiness in all your endeavors. To learn something grate and interesting stuffs in excel, subscribe to excelhub.org. In the year 2019 my target is to publish all 450+ excel functions and many more things here. Excel Calendar for 2019 In this post i will explain you … Read more
Introduction MATCH function in excel is a lookup function. It helps in locating cell number corresponding to a lookup value of a row, column or table. It does this by searching for specific value in a range of cells and returns position of value. For Example, if the range A3:A6 have the values 10, 15, … Read more
Introduction Ceiling function in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to a defined multiple. For example, number 1.5 is rounded up to nearest multiple of 1 by formula =CEILING(1.5,1) which gives 2 as the result. Ceiling function is same as MROUND function except it always … Read more
Introduction Round function in excel is a Math/Trig function. It is a worksheet function. It is used in rounding of a number to a defined number of digits. For example, if cell B1 contains value 2.478 and it needs to be rounded off to one decimal place, one can used ROUND function to return value … Read more
Introduction IFERROR function in excel is a logical function. This function is used in case a formula produces an error. With this one can use a customized value if an error is displayed. It checks for errors like #VALUE! , #NUM! , #N/A! , #REF! , #NAME! etc. If no error is found IFERROR returns … Read more
Introduction FLOOR.PRECISE function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given function to a defined multiple or the nearest integer. It is different from FLOOR function in the sense that whatever may be the sign of the number, it always rounds down. By default it uses 1 … Read more
Introduction NOW function in Excel is a type of DATE/TIME function. This function is used to retrieve present date with time. It is a dynamic function and updates automatically when we change a is made to the file or it is reopened. It gives result in form of serial number which can be formatted in … Read more