Hi, I need to calculate CUMULATIVE weight loss over a number of weeks, and show the result in stones and pounds (that is "st" and "lbs" added as text).
Here's a scenario:
In Week 1, the starting weight is 13 st 6 lbs
In Week 2, the new weight is 13 st 2 lbs, so the loss = 4 lbs
In Week 3, the new weight is 12st 12 lbs, so the cumulative loss, from Week 1 to Week 3 = 8 lbs
In Week 4, the new weight is 12st 5 lbs, so the cumulative loss, from Week 1 to Week 4 = 15 lbs... or 1st 1 lb
Whilst I can manage the basic maths bit, I just can't seem to find a way to include concatenation as well, so that the cumulative total for Week 4 shows as a loss of "1 st 1 lb".
I am more proficient in Excel and, there, I am using this formula: =CONCATENATE(ROUNDDOWN(A1/14,0)," st ",MOD(A1,14)," lbs") where A1 is the weekly weight loss in pounds.
Can anyone help?
Many thanks
Terri