How do a kg to stone convertion in excel

M

Michael Eastwood

I tried doing a v lookup for a kg to stone/pound convertion. The problem
arrises because there is 14 lbs to a stone. Excel dosent recoznise 1 stone
12 lbs for example
 
B

Bill Kuunders

Googled for this one..........

=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&"
lbs"

enter the kg's in A3
You can work with the rounding if you need part pounds.
 
B

Bernard Liengme

As an alternative to Bill's answer
A3 has weight in kilograms
=A3*0.071429
then format with Custom format # ??/14
In this way, 100 kg displays as 7 2/14 meaning 7 stone 2 lbs
best wishes from Canada
 
F

FLKulchar

There is one slight mistake in the above formula...

Thge "*10.0" (times 10) must be changed to "*14.0" (times 14) !!!

OK

FLKulchar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i use excel to calculate weight (as in stone and lbs)? 6
How to format in stones & pounds and then present on chart 1
A few problems involving LOOKUP and SUMPRODUCT... 2
Need to set up a database?? 0
Formatting cell to show body weights 8
Sumifs statemenet returns - , how to use in if statement? 2
How to create a macro in excel so that it can generate a list ofunique records using all permutation 1
Adjacent Cell to Last Cell in a Row 1

Top