Formulas can range from simple arithmetic operations to complex conditional statements. Functions, on the other hand, are built-in tools that simplify common calculations and tasks.

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 ...