let say i want to use the formula =LN(B1/B2) for cell G
instead of typing =LN(B2/B3) and then =LN(B3/B4) for each cell, is there a faster way of doing this?
If you want to add the cells, you either highlight the entire row or column, and click "Auto-Sum" at the top. To check your formulas, press "Ctrl" and "~`" (Tilding).