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

The main reason to use Python is that you get a lot more options than what's included in most spreadsheets. Spreadsheets are ...