Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi GreenMonster ,
if you want fractions in 1/16's or reduced value you must Round the cell value to 1/16 like : (1/16)*INT(A1/(1/16) (also use Complementary function MROUND(A1,1/16) then format the cell with two digits ie : #" "??/?? 9,75 9 3/4 =(1/16)*INT(A1/(1/16)) 6,50 6 1/2 =(1/16)*INT(A2/(1/16)) 7,34 7 5/16 =(1/16)*INT(A3/(1/16)) 7,17 7 1/8 =(1/16)*INT(A4/(1/16)) 7,02 7 =(1/16)*INT(A5/(1/16)) You can also change rounding to 1/32's ou 1/64's Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show fraction as fraction even if answer is 1 | Charts and Charting in Excel | |||
Reducing the size. | Excel Discussion (Misc queries) | |||
Text fraction to fraction format | Excel Worksheet Functions | |||
How do I change fraction to fraction characters? | Excel Worksheet Functions | |||
Reducing A Number By 1 (one) | Excel Programming |