please help - i've been racking my brain on this one
 

I need to look return a futures number from a 4-digit number. (ie.
4866 = 486 3/4)

Basically the 1st 3 digits need to remain as they are but the 4th
number in the cell and assign a fraction... not sure if I'm describing
this well but here is an example.

A question...
1. 4866 (if A1 end in a 0, then result is 0, if A1 ends in a 2 then
result is 1/4, if A1 ends in 4 then result is 1/2, if A1 ends in 6
then results then result is 3/4.) Final result should be 486 3/4.
2. 4772 Final result should be 472 1/4.

Please help - the spreadsheet I'm trying to calculate is huge and will
take me forever to do manually. Any ideas or solutions would be
appreciated.

Thanks,
Maria

please help - i've been racking my brain on this one
 

On Tue, 23 Oct 2007 19:22:51 -0700, wrote:

I need to look return a futures number from a 4-digit number. (ie.
4866 = 486 3/4)

Basically the 1st 3 digits need to remain as they are but the 4th
number in the cell and assign a fraction... not sure if I'm describing
this well but here is an example.

A question...
1. 4866 (if A1 end in a 0, then result is 0, if A1 ends in a 2 then
result is 1/4, if A1 ends in 4 then result is 1/2, if A1 ends in 6
then results then result is 3/4.) Final result should be 486 3/4.
2. 4772 Final result should be 472 1/4.

Please help - the spreadsheet I'm trying to calculate is huge and will
take me forever to do manually. Any ideas or solutions would be
appreciated.

Thanks,
Maria

If A1 can end only with 0,2,4,6, then the following should work:

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

Format as Fraction up to one digit.

If the value can have other endings, then you will need to post back what you
want to happen.
--ron