O'Reilly logo

Hands-On Financial Modeling with Microsoft Excel 2019 by Shmuel Oluwa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Mixed referencing

The following example, which is using the same Sales Report worksheet, seeks to compare sales that are obtained by using MarkUps of 15%, 20%, and 25%.

In this case, the sales is calculated as Cost of Sales × (1+MarkUp %). This is a screenshot of the layout for the markup:

Mixed referencing is required when you need to lock a reference in one direction only, either down or across to the right, but not both. In the following example, you will create the formula in cell I5, and then copy it down through rows 6 to 20 and across columns J and K. The following screenshot shows the calculation of 15% MarkUp:

The base formula is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required