Formula to change 'Stones - Pounds' to Pounds?

papillon

papillon

Board Regular
Joined
Oct 14, 2002
Messages
88
Hi All,
Does anyone know of a formula to change imperial stones and pounds to just pounds eg 13 stones 3 lbs = 185lbs ? (14 pounds to a stone)
Thanks,
papillon
 
Sort by date Sort by votes
Even if the stones.pounds are text, I think the following will do what you are looking for:
=INT(A1)*14+(A1-INT(A1))*10

Never mind, I missed page two or the replies, sorry for being so slow on the uptake.
 
Upvote 0

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Originally posted by AlohaJulio:
Even if the stones.pounds are text, I think the following will do what you are looking for:
=INT(A1)*14+(A1-INT(A1))*10
Click to expand...

Your formula will not work for values such as 11.12, 3.13, 52.11, 127.10, etc. Of course, 'xyz.10' has to be entered as text, or Excel will change it to 'xyz.1'.

(And you're welcome, Red Admiral/papillon.)
 
Upvote 0
You must log in or register to reply here.

Similar threads

Outdoorsman80
  • Question
Calculating Pounds and Ounces
Replies
7
Views
749
Georgiboy
Georgiboy
M
  • Question
Add units/currency on top of the y-axis in line chart
Replies
5
Views
720
awoohaw
awoohaw
Ironman
  • Solved
Formula to convert stone and pounds into pounds
Replies
7
Views
1K
Peter_SSs
Peter_SSs
Obewan
  • Question
Name extraction
Replies
8
Views
317
Peter_SSs
Peter_SSs
Obewan
  • Solved
Formula to delete data from a cell
Replies
8
Views
275
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,833
Messages
6,127,162
Members
449,368
Latest member
JayHo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top