View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Modeste[_3_] Modeste[_3_] is offline
external usenet poster
 
Posts: 2
Default reducing a fraction

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