How to use concatenation to clarify assumptions

In addition, it shows operating income at different sales volumes.

If we change an assumption, the model recalculates.

A better way to expose values in the table is to add them directly to the labels using concatenation.

We can do this using the ampersand symbol.

First, add an equal sign to turn the label into a formula.

Then, wrap the existing text in double quotes.

Next, add an ampersand character and point to the cell with the correct value.

The ampersand joins the two values.

And the @ symbol will make things more readable.

Now, if we change the selling price, the label is updated to match.

The TEXT function converts numbers to formatted text.

In this case, we’ll use a Standard currency format with commas, and without decimals.

Now we have a formatted value in our label.

I’ll fast forward here to update the other labels.

Now when assumptions change, the labels in the table are updated to match.

it’s possible for you to use this same approach to highlight assumptions in any model.