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
assuming figure in A1
=int(A1/10)+(a1-int(a1/10)/8)
2+2=9 ... (My Arithmetic Is Mental)
=INT(A1/10)+(A1-INT(A1/10)*10)/8
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Ooops ! that'll teach me to try before I buy !!!!!
2+2=9 ... (My Arithmetic Is Mental)
Thank you both!! Very much appreciated!
Here's another approach.
=INT(A1/10)+MOD(A1,10)/8
Norie, that's even neater
2+2=9 ... (My Arithmetic Is Mental)
Posting Permissions
Reply With Quote
