摘要:
It's often useful to avoid repeating lengthy expressions. Here's one technique for reusing expressions.
Consider the chart below. The Expression for the column labeled "Net" is:
=sum(Quantity * Price) * (1-Discount)
Let's add another column for "Commission", defined as 10% of Net. Instead of repeating the Net calculation, use the expression:
=Net * .1 阅读全文