S preadsheets have come a long way since the days of manually dragging formulas and copy-pasting data as if your life depended on it. Let’s just say there’s a newer, smarter approach, and it starts ...

There are a couple of problems here that make this formula complex. The most glaring one is that the calculation for the subtotal ( 1000 * 3) is repeated twice, making the formula hard to read. It's ...