Arte SheetsLearn. Try. Understand.

Clinical Medicine & Physiology

Understanding nutritional screening and weight-change percentages

Learn how a spreadsheet calculates percentage weight change and where to find BAPEN’s official MUST screening resources.

Nutritional screening and the official MUST resource

The Malnutrition Universal Screening Tool (MUST) was developed by the Malnutrition Advisory Group of the British Association for Parenteral and Enteral Nutrition (BAPEN). It is designed to support identification of adults at risk of malnutrition. For the full instrument, its interpretation and conditions of use, consult BAPEN’s official resources linked below.

This page does not reproduce the MUST scoring instrument or replace an assessment by a qualified professional. Nutritional risk cannot be determined from a weight-change calculation alone.

Practice percentage weight change

This independent arithmetic example compares a previous weight in B2 with a current weight in B3, using the same unit for both. It returns a negative value for a decrease, positive for an increase and zero for no change. For 80 kg and 74 kg, the change is −7.5%. The time period and whether a change was intentional must be understood separately.

=IF(COUNT(B2:B3)<>2,"Enter two numeric weights",IF(OR(B2<=0,B3<=0),"Weights must be positive",ROUND((B3-B2)/B2*100,2)))

What the calculation cannot tell you

A percentage alone cannot diagnose malnutrition or choose a diet or treatment. Measurement conditions, illness, fluid changes, weight history and other factors may matter. Obtain the current screening instrument and clinical guidance from their authors.

Try the example

Use the original values or change them to test your understanding.

Further reading