PDA

View Full Version : Fixing Numbers



blumfeld0
07-28-2007, 09:07 PM
Hi. I have a column in excel with like a thousand different numbers like 1564, 5560, 2504, 720, 474, 12 etc.
The problem is that 1564 doesn't mean 1564 it means 156.5
5560=556, 2504=250.5, 720 = 72 and 4742=474.25, 12 =1.25
basically whatever the last digit of the number is, it gets divided by 8.
Is there anything i can do in excel -maybe write some kind of command or some option- to spit out the actual number in a different column?
thanks

unmarkedhelicopter
07-29-2007, 12:52 AM
assuming figure in A1
=int(A1/10)+(a1-int(a1/10)/8)

Bob Phillips
07-29-2007, 02:18 AM
=INT(A1/10)+(A1-INT(A1/10)*10)/8

unmarkedhelicopter
07-29-2007, 06:12 AM
Ooops ! that'll teach me to try before I buy !!!!! :(

blumfeld0
07-29-2007, 06:39 AM
Thank you both!! Very much appreciated!

Norie
07-29-2007, 07:07 AM
Here's another approach.

=INT(A1/10)+MOD(A1,10)/8

unmarkedhelicopter
07-29-2007, 07:47 AM
Norie, that's even neater :)