Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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. * *


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"