by Ilker | Jan 16, 2019 | Excel Formulas
Excel TEXT function helps apply a certain formatting to a numeric value. You can think this function as an alternative to number formatting. In this guide, we’re going to show you how to use the TEXT function and also go over some tips and error handling methods....
by Ilker | Jan 14, 2019 | Excel Tips & Tricks
The Format Painter is the life saver when you need to copy only the formatting settings from one section to the other in your spreadsheet. In this guide, we’re going to show you how to use format painter in Excel. The best part is, this feature is supported by pretty...
by Ilker | Jan 11, 2019 | Excel Formulas
The MROUND function rounds a number to the nearest multiple of a specified number. In this guide, we’re going to show you how to use the MROUND function and also throw in some tips and error handling methods. Supported versions All versions Syntax...
by Ilker | Jan 11, 2019 | Excel Formulas
The ROUNDDOWN function rounds down a number to a specified number of digits. In this guide, we’re going to show you how to use the ROUNDDOWN function and also throw in some tips and error handling methods. Supported versions All versions Syntax...
by Ilker | Jan 11, 2019 | Excel Formulas
The ROUNDUP function rounds up a number to a specified number of digits or decimals. In this guide, we’re going to show you how to use the ROUNDUP function and also throw in some tips and error handling methods. Supported versions All versions Syntax...
by Ilker | Jan 11, 2019 | Excel Formulas
The ROUND function allows you to manage the decimal portion of a numeric value. It rounds a number to a specified number of digits. In this guide, we’re going to show you how to use the ROUND function and also throw in some tips and error handling methods. Supported...
by Ilker | Jan 9, 2019 | Excel Formulas
The AVERAGE function can calculate the average (arithmetic mean) of the values in a range of cells. In this guide, we’re going to show you how to use the function and also throw in some tips and error handling methods. Supported versions All versions Syntax...
by Ilker | Jan 9, 2019 | Excel Formulas
The SUM function can sum up the values in a range of cells. In this guide, we’re going to show you how to use the SUM function and also throw in some tips and error handling methods. Supported versions All versions Syntax SUM(number1,[number2],...) Arguments number1...
by Ilker | Jan 9, 2019 | Excel Formulas
The TODAY function returns the serial number of the current date without the time information. The return value gets updated with every recalculation. In this guide, we’re going to show you how to use the TODAY function and also throw in some tips and error handling...
