# Category: Formulas

## How To Conditionally Concatenate A Range

This formula will conditionally concatenate a range based on a criteria in another range.

## How To Solve a Quadratic Equation

These formulas will give the solutions to a quadratic equation.

## How To Select A Random Item From A List

This formula will return a random selection from a given list with each item in the list having an equal probability of being selected.

## How To Create A Hyperlink To The Current Workbook Folder

This formula will create a hyperlink that opens a file explorer window to the folder location where the current workbook is saved.

## How To Get The Current Workbook Folder Path

This formula will return the folder path where the current workbook is saved.

## How To Calculate The Volume Of A Sphere

This formula will calculate the volume of a sphere given its radius.

## How To Count The Number Of Items Less Than The Average

This formula will take the average of a numerical range then return the count of the items in the range that are less than the average.

## How To Calculate The Area Of A Circle

This formula will calculate the area of a circle given its radius. #### Follow #### Microsoft MVP  #### Recent Posts 