课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Applying formula triggers to prevent inaccurate results

Applying formula triggers to prevent inaccurate results - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

Applying formula triggers to prevent inaccurate results

“

- [Instructor] Here we've got data about candidates. We've got their reviews, 1 through 4, the session that they're applying for, and you and I are planning for session B. Successful candidates have to score at least 15 points and the scoring is 0 through 5. And let's look at the data. H113 is applying for session A and has zero points. And we could imagine somebody looking over our shoulder and saying, "Oh, 0, 5, 8, 4, 7, wow, it's pretty low scores." And then they move on. But they didn't see that these zeros are because there are no scores for them. The 7 for K300 is a 5 plus a 2. Just two scores while we're waiting for two scores. This is where formula triggers can be really handy. A formula trigger means that you've got a formula, but you don't want it to do anything until certain criteria are met. So let's build a trigger. Right now, in H6, I have a sum of reviews 1 through 4. Okay. I'm going to go…

内容