课程: Excel Weekly Challenge

免费学习该课程！

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

Calculate final cost and set data validation

Calculate final cost and set data validation - Microsoft Excel教程

课程: Excel Weekly Challenge

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

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…

内容