Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
please help - i've been racking my brain on this one
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Brain Dead | Excel Discussion (Misc queries) | |||
Brain Dead: Need help with ???? | Excel Worksheet Functions | |||
Formula Problem - Get your brain around this.. | Excel Discussion (Misc queries) | |||
Subtraction brain block | Excel Discussion (Misc queries) | |||
My brain hurts... | Excel Discussion (Misc queries) |