Excel gurus - formula help please?

Stan_Lite · 18-11-2009, 10:26

I have a spreadsheet where I can input my weight in kilos and output it in pounds (extremely simple task). I decided I'd like it to do it in stones and pounds instead.

After much searching on t'interweb, I found the following formula

Code:

= INT(ROUND(A2*2.204623,0)/14)&"st "&TEXT(MOD(ROUND(A2*2.204623,0),14),"0")&"lb"

This works fine but it rounds it to the nearest pound. I'd like it to round to the nearest half pound but I can't work out for the life of me how to do it

Help please

18-11-2009, 10:26	#1
Stan_Lite Stan, Stan the FLASHER MAN! Join Date: Jul 2006 Location: In bed with your sister Posts: 5,483	Excel gurus - formula help please? I have a spreadsheet where I can input my weight in kilos and output it in pounds (extremely simple task). I decided I'd like it to do it in stones and pounds instead. After much searching on t'interweb, I found the following formula Code: = INT(ROUND(A22.204623,0)/14)&"st "&TEXT(MOD(ROUND(A22.204623,0),14),"0")&"lb" This works fine but it rounds it to the nearest pound. I'd like it to round to the nearest half pound but I can't work out for the life of me how to do it Help please __________________ Just because I have a short attention span doesn't mean I...

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode