Display the unit symbol in the formula result

Uploaded time: January 24, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

Display the unit symbol in the formula result

Display the unit symbol in the formula result

This is a table of information about the department employees. If we need to calculate the average weight of the staff, what should we do?

Normally, you only need to enter the formula =AVERAGE(D2:D8) in cell D9 to get the average.

However, the formula returns 0, and obviously, the result is incorrectbecause there are text characters in the cells, which affects the accuracy of the calculation.

Do you know how to retain the weight unit and normally perform the calculation at the same time?

At this time, we can customize the cell format to solve this problem.

Select the range of cells to which we want to apply the calculation, and press the shortcut Ctrl+1. In the pop-up dialog, select Custom.

Enter the formula 0kg in the edit box, where 0 represents the numeric placeholder, and double quotes represent the quoted text.

Then click to confirm.  When we enter the input number, the unit symbol kg will be added after the number automatically .

Enter the formula =AVERAGE(D2:D8) in cell D9, and now you can get the correct calculation result with the weight unit.

What a practical feature! Did you get it?