From the course: Excel: Advanced Formulas and Functions (2023)

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Build complex formulas in steps

Build complex formulas in steps

From the course: Excel: Advanced Formulas and Functions (2023)

Start my 1-month free trial Buy for my team

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 buttons. Okay, now I'm going to go over here and do a friend count equals count A. And…

Contents