Formulas

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

These formulas will give the solutions to a quadratic equation.

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

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

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

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