Function: EXACT

Function: EXACT

by | Jan 28, 2019

Excel EXACT function compares two strings and returns TRUE for a perfect match, and FALSE if not. Note that this comparison is case-sensitive. In this guide, we’re going to show you how to use Excel EXACT function to compare strings and also go over some tips and...
Function: TEXT

Function: TEXT

by | Jan 16, 2019

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....
Rounddown Function in Excel

Rounddown Function in Excel

by | Jan 11, 2019

Prepare to enhance your precision in Excel! The ROUNDDOWN function is your key to precise numerical manipulation. In this brief guide, we'll provide valuable insights and expert advice on mastering the ROUNDDOWN function. Learn efficient techniques for rounding down...
Function: ROUNDUP

Function: ROUNDUP

by | Jan 11, 2019

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...
Function: SUM in Excel

Function: SUM in Excel

by | Jan 9, 2019

Welcome to our comprehensive guide on using the SUM function in Excel. This is a fundamental tool for calculating the total of values within a range of cells in Excel. In this guide, we'll provide a detailed walkthrough of how to effectively utilize the SUM function...
Function: TODAY

Function: TODAY

by | Jan 9, 2019

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...
Function: N

Function: N

by | Jan 8, 2019

The N function is an information function that returns a value converted to a number. In this guide, we’re going to show you how to use the N function and also throw in some tips and error handling methods. Supported versions All versions Syntax N(value) Arguments...
Function: OR

Function: OR

by | Dec 26, 2018

The Excel OR function is a comparison function that returns TRUE if at least one of the specified conditions is TRUE. If no condition is met (FALSE), the return value is FALSE. In this guide, we’re going to show you how to use the Excel OR function and also go over...
Function: AND

Function: AND

by | Dec 26, 2018

Excel AND function is a logic comparison function that returns TRUE, if all specified conditions are met, and FALSE, if they're not. It In this guide, we’re going to show you how to use Excel AND function and also go over some tips and error handling methods....