From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using mixed references in formulas

Using mixed references in formulas

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using mixed references in formulas

“

- We're look at a worksheet called Mixed References. As you can pretty quickly see what we're about to do, we've got 900 couches, 800 recliners, 600 coffee tables, and so on. And, out of these 900, we need to distribute them, 25% of them go to the Eastern region, 20% to the Midwest, and so on. Off to the right, we see this. So, a simple little formula here to calculate these numbers is going to be pretty easy to set up. And the numbers are nice, round, easy numbers, so we can do a lot of the math in our heads, or at least have verifiable answers pretty quickly. So a simple formula, here, in cell C4, is going to be equal, and we need to multiply those two numbers, and in no particular order. So we can take the 25% first, or the 900 first, it makes no difference. Asterisk for multiplication, of course. And the other entry. And we're all set. Now, we could do that for each of the other cells, but how many cells do we have here? That's 35 cells. We don't want to do this 34 more times…

Contents