Using Excel to make the profit and loss calculation method of similar shop

1, the following picture describes the store's profit loss flat state relationship, now our goal is how to express the yellow column;

2, the amount of the value of the column to the right of the amount of the column, and then select this column, click on the small button to the right of the number, open the Format Cell Formatting window, and then select the number options, under the category to select a custom, in the type of the bar box into the " Loss ";" Flat ";

3, after the completion of the input, click OK, the amount listed on the profit and loss level, in order to display their specific figures, we can select the amount of columns, modify the formula, that is, after three Chinese characters to add 0, the operation step effect of the following figure description;

4, but we also found that the deficit should be expressed in negative numbers, we again select the amount of column, to the loss of the following 0 add a minus, edit the "formula" as shown below;

5, after the above operation steps, the profit and loss status of the shop can be described as the following figure.