# Category: Formulas

## How To Conditionally Concatenate A Range

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

Read More## How To Solve a Quadratic Equation

These formulas will give the solutions to a quadratic equation.

Read More## 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.

Read More## 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.

Read More## How To Get The Current Workbook Folder Path

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

Read More## How To Calculate The Volume Of A Sphere

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

Read More