Yang Sun App Studio
Back to Blog
2026-11-175 minUtility

Why is L1 - 20% not the same as subtracting 20 or taking one fifth?

Why is L1 - 20% not the same as subtracting 20 or taking one fifth?

Author: SunClaw Team · Updated: 2026-11-17

The short answer

In CalcList, a percent that stands alone after a plus or a minus is a fraction of the value on the left. That fraction is then added or subtracted.

When L1 is 100:

FormulaThis rowIs L1 still in the total?
L1 - 20%80No. The total is 80
L1 + 15%115No. The total is 115
L1 * 20%20Yes. The total is 120
L1 * 8%8Yes. The total is 108

L1 - 20% is 80% of L1. It is not "subtract 20" and it is not one fifth. L1 * 20% is the one fifth, which is 20. The order of a discount and a tax is in discount, then sales tax. This page is only the percent mark on a list.

Why the total is not 100 plus 80

If a row, at the top level, adds or subtracts an earlier row, that earlier row is not added into the total again. When L2 is L1 - 20%, L1 has been consumed by that plus-or-minus. The total keeps L2's 80. It does not become 180.

Multiply and divide do not mark the earlier row as consumed. When L2 is L1 * 20%, L1's 100 and L2's 20 both enter the total, which is 120. If you wanted the discounted price 80, use the minus form. Do not use multiply and then hope the total will drop the original price for you.

A row whose operation is = is shown and kept out of the total. That is the row to use for a per-person split. It will not be added on top of the bill.

A reference can only see earlier rows

Row 1 cannot reference any row. The keyboard says the first row cannot reference. The engine also rejects a reference to itself or to a later row. That is a forward reference, and the row errors.

A reference to an empty row counts as 0. A reference to a row that already errored makes this row error too. Division by zero errors. It does not invent a number.

A discount list can look like this:

  1. The original price, formula 100.
  2. L1 - 20%, which is 80, and the total is 80.
  3. For the tax, a new row L2 * 8%, which is 6.4. That row is a multiply, so it does not remove row 2 from the total. The total becomes 86.4.

If row 3 is written L2 + 8%, the row itself is 86.4, and row 2 is marked consumed. The total is only 86.4, not 80 + 86.4. The two writings differ both on the row and in the total. To keep the tax visible as its own row and keep the discounted price in the total, use the multiply.

FAQ

Q: Is L1 - 20% the same number as L1 * 80%? A: On that row, yes. Both are 80% of L1. In the total, no. The minus removes L1 from the total. The multiply does not.

Q: Why can't the first row say L1? A: A reference can only point at an earlier row. Row 1 has none. L1 there is a forward reference.

Q: Does a blank row above make the next row fail? A: No. An empty row counts as 0. A row that already errored is what makes the reference fail.

Q: Can I put a later 8% tax in the same minus? A: Don't pack it into one minus. Take L1 - 20% for the discounted price, then a multiply on the next row for the tax. Stacked discounts are in the discount article.

Decide whether the row is the discount or a slice of tax

If you want "80% of what it was," write L1 - 20%. If you want "20% of it, as a separate amount," write L1 * 20%, and expect the original row to stay in the total.

CalcList

#CalcList#percent#discount#row reference