I’m setting up a spreadsheet to monitor weight gain or loss following recent illness. Can anyone tell me the syntax I need to compare decimals (Kg weight) to a fixed decimal (F1) and express the answer as a percentage.
This will enable me to monitor daily weight gain or loss, please? Below is a screenshot The constant (original weight) is in cell F1. I wish enter each day’s weight in Column B and have that weight compared to original weight and expressed as a +/- %. I am using digital bathroom scales, calibrated to kilograms (and decimals thereof). The scales can also be calibrated to ‘pounds / stones’. Since Australia decimalised, I am now able to understand most (but not ALL) metric measures. Yours faithfully, Paul Collins,
