课程: Excel Weekly Challenge

免费学习该课程！

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

Write a sentence with dynamic values

Write a sentence with dynamic values - Microsoft Excel教程

课程: Excel Weekly Challenge

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

Write a sentence with dynamic values

“

- [Instructor] An event is being planned and we have to keep our eye on the capacity. Right now there are 61 guests confirmed, the capacity is 120. In cell E2, we want a couple of things. We want a dynamic statement that says how many guests, comma, and then the number of seats that are available. But if we do get to say 125, there's no such thing as -5 seats available. No. When capacity is exceeded, show the statement that's on Sheet2 in cell C2. And I'm not going to show that to you. You should be able to get there and hook all of this up, all right? Good, okay. And finally, test, test, test. Change the numbers. Make sure that the statement updates properly and when you go over the capacity that it lets you know that you're over capacity. All right, pause the video, work that out and then come on back. (upbeat music) Okay, let's do it. The first thing I'm going to do, go over here and do some…

内容