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.

Correct these calculations

Correct these calculations - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Correct these calculations

“

- [Instructor] We've got this summary sheet. We look over in the After Revenue share column. Yeah, there is an error, so we need to troubleshoot that and get that fixed, whatever's goin' on there. Then, in the Bees and Apiary column, and Kitchenware column the numbers are identical. That does not seem right. So can you verify that, troubleshoot the formulas, get that fixed? So go ahead, pause the video, get the exercise file figure this out, come back, and we'll get this fixed. Okay, you're back. Alright, let's start with this After Revenue share formula. Highlight here, I'm going to go up here, that looks fine. But let's think about what this formula is doing. It's taking C4 which is Fabric and Sewing adding that to Lighting then adding that to Bees and Apiary. And then, it takes the Kitchenware value, multiplies that by 0.75 and adds that to the rest. Okay. Let's hit enter. That looks fine. Let's go here. Oh.…

Contents