How to Return the File Pathway of an Excel Workbook Using a Formula

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...

top of page

How to Return the File Pathway of an Excel Workbook Using a Formula

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...

How to Use the CELL Function in Excel

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

Creating Fully Playable Yahtzee in Excel

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...

How to Return the ASCII Number for Every Character in a Cell

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

How to Use the CODE Function

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

How to Round a Date to the First of the Next Month

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

How to Round a Date to the First of the Previous Month

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

How to use the LOG Function

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

How to use the LN Function

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

How to use the GCD Function

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

How to Remove Date Data from a Time in Excel

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

How to Remove Time from a Date in Excel

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

How to use the AVERAGE Function

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

How to use the DELTA Function

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....

How to use the CLEAN Function

The CLEAN function removes all non-printable characters from a text string. Characters like line breaks, tabs, and other characters that...

bottom of page