Recent Posts

How to Highlight Cells Containing a Formula in Excel

To highlight any cell that contains a formula in an Excel workbook, there is a simple conditional formatting formula that can be used....

Sometimes you'll find yourself needing to pull a file's pathway into your Excel sheet. Luckily there is a quick formula we can use to...

The CELL function is a useful tool that allows you to retrieve specific information about a cell's formatting, location, and content....

Contents: 1. Download 2. How to Play 3. How Does it Work? 3.1 Dice Display 3.2 Rolling & Freezing Dice 3.3 Score Keeping & Entry 3.4 Turn...

The formulas below will take any text input and return the ASCII value of each character that comprises that string. Contents: 1....

The CODE function will return the ASCII value of the first character from any text string. Contents: 1. Syntax 2. Explanation 3. Examples...

Contents: Formula Explanation Example - Rounding Dates to First of the Next Month Formula = EOMONTH(date, 0) + 1 By feeding any date into...

Contents: Formula Explanation Example - Rounding Dates to the First of the Previous Month Formula = EOMONTH(date, -2) + 1 By feeding any...

The LOG function will calculate the logarithm of any given number to a specified base. Contents: 1. Syntax 2. Explanation 3. Examples...

The LN function will calculate the natural logarithm of any given number. Contents: 1. Syntax 2. Explanation 3. Examples 3.1. Calculating...

The GCD function finds and returns the greatest common divisor (GCD) of two or more numbers. Contents: 1. Syntax 2. Explanation 3....

Having dates associated with times in Excel can sometimes throw off time calculations. Luckily, there is an easy way to strip out date...

Having time associated with dates in Excel can sometimes throw off date calculations. Luckily, there is an easy way to strip out time...

The AVERAGE function returns the arithmetic mean of any set of numbers given to it. Contents: 1. Syntax 2. Explanation 2.1. Types of...

The DELTA function compares two numbers and returns a 1 if they are the same, and a 0 if they are not the same. Contents: 1. Syntax 2....