Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I don't know the function FRAC but whatever it is the syntax should
be: =INT(A2)+INT(FRAC(A2*100)/60)+FRAC(FRAC(A2*100))/36 Reasoning: You choose one cell to hold your variable x, say A2. Thus your formula refers to A2 wherever there is an x. I don;t know what you mean exactly and this determines the parentheses. For example, in your second term: int (frac x*100)/60 If you mean that you divide the result of INT with 60 then the expression is: INT(FRAC(A2*100))/60 If you want to divide frac x*100 with 60 and then take the integer part then you use the variant above: INT(FRAC(A2*100)/60) HTH Kostis Vezerides On Nov 22, 2:44*pm, melz wrote: *how to do this in * *= int x + int (frac x*100)/60 + frac (frac x*100)/36 can someone help me. * * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|