At 10:42 01/09/2022 +1000, Paul Collins wrote:
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.
If you "compare" two values, you do not get an answer! Do you want
(using your sample values) your 57.7 to be expressed as 100.5% of
57.4 (which it is), or do you, since you are talking about gain and
loss, want that extra 0.3 to be expressed as 0.52% of the original
57.1 (which it also is)? I'm guessing the latter.
This will enable me to monitor daily weight gain or loss, please?
Below is a screenshot. The constant (original weight) is in cell F1.
So it's odd you use F3 in your formula (or A1 for that matter).
I wish enter each day's weight in Column B and have that weight
compared to original weight and expressed as a +/- %.
So the *difference* expressed as a percentage?
=(B3-F$1)/F$1 will find the fractional change. (The dollar signs
prevent the reference to F1 being automatically changed as you fill
or copy the formula down column C.) You can express this as a
percentage in one of two ways: either simply format your results
column C as Percent, or use
=(B3-F$1)/F$1*100 instead.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
