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 final cost and set data validation

Calculate final cost and set data validation - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Calculate final cost and set data validation

“

- [Instructor] Okay, there's a lot here, so let me explain what we're looking at, because ultimately we want to write a formula that will dynamically calculate the final cost that's in cell C16. So I'm going to play with some of the inputs. So we've got a 2-Level, and it brings over the base price of 3,875. So let me go ahead and change this with a drop-down list to a 1-Level, it brings it over to 3,000. And then we have a delivery option of $0 or $200. And then we have two different discount grids. So right now you can see for an 800-square-foot order the discount is 17% and look at that, over in the 1-Level grid, okay. But now let's change this to the 2-Level. Now this is 17 1/2. Our first step write a formula that generates the final cost by adding the base price plus the delivery and then taking off any discount, if any. Next thing, set data validation in cell C8 so that it only takes a whole number between the…

Contents