From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Calculate team fees

Calculate team fees - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Calculate team fees

“

- [Instructor] Got a lot to do this week, so let's dive in. We are going to calculate team fees. We want to write a dynamic formula in column E. And to calculate that fee, that needs to be the registration fee of $300 plus the fee per person of 85 times the team count number. So, with the Bumblebees, that would be $300 plus 85 times 10. The next step would be to use conditional formatting to highlight teams that have too few or too many players. Finally, test that our result is dynamic by changing the registration fee to $200 and Helium's team count to nine, and make sure everything changes in updates. All right, pause the video. Work that out. Come back. We'll go through it together. All right, let's do it. First of all, I'm going to put everything into a table. Here we go. Click inside the dataset, Format As Table. Let's click this hot pink. Table does have have headers, OK. Get rid of these filter…

Contents