Learn about how to Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA.
Topics in Video:
(01:19) FORMULATEXT & ISFORMULA & IF Functions to create formula to show formula in cell
(02:50) Average Formula using SUMPRODUCT and COUNT so we can calculate average of Units and Price columns
(03:57) Standard Deviation using Helper Column, using the STDEV.P Function.
(04:27) Array Formula for calculating Standard Deviation from Price and Units Columns using STDEV.P Function and the keystroke Ctrl + Shift + Enter