2014年2月12日
摘要: 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 阅读全文
posted @ 2014-02-12 22:08 ITPCBI 阅读(265) 评论(0) 推荐(0) 编辑