Stones & pounds in Excel

  Dirty Dick 10:18 30 Apr 2010
Locked

Well, it’s diet time again !!

I’m on a diet and have set up an excel spreadsheet to record my weight loss (or gain !!) . I have column A that records the weight in kilograms, and column B has the weekly weigh-in dates. In column C I have a formula to convert Kilos to Imperial (Stones & pounds) because I am still a dinosaur. The formula I am using is

=IF(A2="","",IF(ROUND(MOD(A2*2.203,14),0)=14,ROUNDDOWN(A2*(2.203/14),0)+1&" st 0 lbs",ROUNDDOWN(A2*(2.203/14),0)&" st "&ROUND(MOD(A2*2.203,14),0)&" lbs"))

This converts to stones & pounds but when I try to do charts, I have no problem with the one in kilos, but the one in Imperial measurements will not register. I think its because column C shows the weight as 10 st 13 lbs (you may think I don’t need to lose weight but this isn’t mine !!)

How can I make a chart that will read the data in Imperial measurements?

Many thanx

DD

  VoG II 10:52 30 Apr 2010

Your values in column C are text, so they won't plot.

See if you can adapt Jon Peltier's approach click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse draws on iconic heritage for a fresh brand identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans échec ?