View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default how to do this in int x + int (frac x*100)/60 + frac (fracx*100)/

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. * *