How to use the LOG10 functions in Excel Enter your data or use existing data. Type into the cell where you want to place the result =LOG10 (A4). Press Enter to see the result. The result is 1.653213.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.