课程: Excel: Advanced Formulas and Functions

今天就学习课程吧！

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

Build complex formulas in steps

Build complex formulas in steps

课程: Excel: Advanced Formulas and Functions

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

Build complex formulas in steps

“

- [Speaker] Let's talk about building solutions. What we want to end up with is a value in F1 that says how much each person has to pay for this skydiving trip. In column B, there's a list of friends who have said they're interested in going, and then we have Clayton, Jaz and Saeed have paid a deposit. Everybody's going to split the cost of the van, and that's $111 and 84 cents. And then we need a skydiving total. So, let's look at the skydiving pricing. It's $300 for each person. Or, for a group of seven up to 11, it's $270. A group of 12 to 15 will pay a flat rate of $2,999. Now how do we approach this, given some of what we've seen previously in the course? We could write a really big formula, helper columns, Lookup arrays. Let's see one way of going about this. So first, put this data into a table, formatted this table and let's grab this dark blue. Table has headers. Okay, get rid of the filter…

内容