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
Introduction HYPERLINK function in excel a shortcut function that creates a shortcut in the cell in which it is used. This shortcut may contain a reference to another cell of the same worksheet or another worksheet OR may contain a link to a network, internet, web, and intranet. When one clicks on the cell containing … Read more
Introduction WORKDAY function in Excel is a type of DATE/TIME function. This function is used to retrieve a date which represents a number of working days in future or past of a specified date. This function also omits any holidays or weekends which are specified in the syntax. This function was introduced in Excel 2007 … Read more
Introduction FLOOR function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given number to the nearest multiple , towards zero. For example, number 1.5 is rounded down by significance 1 to the nearest integer towards zero by formula =FLOOR(1.5,1) which gives 1 as the result. FLOOR function is … Read more
Introduction EVEN in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to the nearest even integer. For example, number 1.5 is rounded up to the nearest even integer by using the formula =EVEN(1.5) which gives 2 as the result. It can also be used to find the … Read more
Introduction IF comes in the category of logical functions. IF function can be used for logical comparison of values and to get the first result when the comparison is TRUE and second result when the comparison is FALSE. It is evaluated by putting various logical operators like “=”,”>”,”<” etc. in the formula .IF function is … Read more
Introduction FIXED function in excel is a String/Text function. It is a worksheet function. It rounds the given number to a defined number of decimal places. It changes the format of the number into decimal format by using commas and period. Its result is in form of a text representation of the given number. For … Read more