Category: Formulas
How To Conditionally Concatenate A Range
This formula will conditionally concatenate a range based on a criteria in another range.
Read MoreHow To Solve a Quadratic Equation
These formulas will give the solutions to a quadratic equation.
Read MoreHow 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 MoreHow 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 MoreHow To Get The Current Workbook Folder Path
This formula will return the folder path where the current workbook is saved.
Read MoreHow To Calculate The Volume Of A Sphere
This formula will calculate the volume of a sphere given its radius.
Read MoreAdvertisement
Categories
Recent Posts

Excel to Jira TableApr 7, 2018  VBA

Everything You Need to Know About Excel TablesMar 18, 2018  Tutorials

11 Awesome Examples of Data ValidationMar 10, 2018  Tips & Tricks