A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is there a formula to calculate the least common denominator?



 
 
Thread Tools Display Modes
  #11  
Old April 28th, 2009, 05:05 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default Is there a formula to calculate the least common denominator?

No, my clock is fine. The message below was sent at 9:15 am local time, and
that's how it shows up in my newsreader. This one is being sent at about 10:05 am.

Pete_UK wrote:
Glenn, I think your system clock is an hour out.

Pete

On Apr 28, 4:15 pm, Glenn wrote:
How did you come up with 5 as the answer?

  #12  
Old April 28th, 2009, 05:15 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default Is there a formula to calculate the least common denominator?

Shows 10:05 here...

Glenn wrote:
No, my clock is fine. The message below was sent at 9:15 am local time,
and that's how it shows up in my newsreader. This one is being sent at
about 10:05 am.

Pete_UK wrote:
Glenn, I think your system clock is an hour out.

Pete

On Apr 28, 4:15 pm, Glenn wrote:
How did you come up with 5 as the answer?

  #13  
Old April 28th, 2009, 05:18 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default Is there a formula to calculate the least common denominator?

Actually, that would "Least Common Multiple" and "Greatest Common Divisor".


David Biddulph wrote:
The least common denominator of those numbers is in fact not 5, but
24000000. =LCM(A1,A2)
If you wanted the highest common factor it would be 600000. =GCD(A1,A2)
--
David Biddulph

"Gizmo" wrote in message
...
The numbers I am working with are 3,000,0000 and 4,800,000. I know the
answer is 5. I need to come up with a formula that will give me the
answer
of 5.

"Glenn" wrote:

Gizmo wrote:
I am trying to find a formula that will give me the least common
denominator
for doing a cost account spreadsheet with sales mix.

It might be possible to help if you provided sample data and expected
results.



  #14  
Old April 28th, 2009, 08:56 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Is there a formula to calculate the least common denominator?

Perhaps the problem is in your time zone settings? Your message headers say
that you are on UTC-6 hours.

The message that you say was at 09:15 in your local time was thus shown as
15:15 UTC. Pete's reply to it was at 14:32 UTC.
--
David Biddulph

Glenn wrote:
Shows 10:05 here...

Glenn wrote:
No, my clock is fine. The message below was sent at 9:15 am local
time, and that's how it shows up in my newsreader. This one is
being sent at about 10:05 am.

Pete_UK wrote:
Glenn, I think your system clock is an hour out.

Pete

On Apr 28, 4:15 pm, Glenn wrote:
How did you come up with 5 as the answer?





  #15  
Old April 28th, 2009, 11:22 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default Is there a formula to calculate the least common denominator?

Set to: (GMT-06:00) Central Time (US & Canada)

Which is correct for my location.


David Biddulph wrote:
Perhaps the problem is in your time zone settings? Your message headers say
that you are on UTC-6 hours.

The message that you say was at 09:15 in your local time was thus shown as
15:15 UTC. Pete's reply to it was at 14:32 UTC.
--
David Biddulph

Glenn wrote:
Shows 10:05 here...

Glenn wrote:
No, my clock is fine. The message below was sent at 9:15 am local
time, and that's how it shows up in my newsreader. This one is
being sent at about 10:05 am.

Pete_UK wrote:
Glenn, I think your system clock is an hour out.

Pete

On Apr 28, 4:15 pm, Glenn wrote:
How did you come up with 5 as the answer?





  #16  
Old April 29th, 2009, 11:46 AM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Is there a formula to calculate the least common denominator?

Are you in an area which doesn't use Daylight Saving Time? Isn't the
Central Time zone now currently on Central Daylight Time, which is UTC-5?
(Central Standard Time is UTC-6).
--
David Biddulph

"Glenn" wrote in message
...
Set to: (GMT-06:00) Central Time (US & Canada)

Which is correct for my location.


David Biddulph wrote:
Perhaps the problem is in your time zone settings? Your message headers
say that you are on UTC-6 hours.

The message that you say was at 09:15 in your local time was thus shown
as 15:15 UTC. Pete's reply to it was at 14:32 UTC.
--
David Biddulph

Glenn wrote:
Shows 10:05 here...

Glenn wrote:
No, my clock is fine. The message below was sent at 9:15 am local
time, and that's how it shows up in my newsreader. This one is
being sent at about 10:05 am.

Pete_UK wrote:
Glenn, I think your system clock is an hour out.

Pete

On Apr 28, 4:15 pm, Glenn wrote:
How did you come up with 5 as the answer?





  #17  
Old May 16th, 2009, 10:39 PM posted to microsoft.public.excel.worksheet.functions
Greg Lovern
external usenet poster
 
Posts: 54
Default Is there a formula to calculate the least common denominator?

Hi Gizmo,

The easiest way to do that is with xlpREDUCEFRACTION():

http://precisioncalc.com/xlpREDUCEFRACTION.html

BTW, xlpREDUCEFRACTION is not limited to Excel's 15 significant
digits. It can reduce fractions where the numerator and/or denominator
have as many as 32,767 significant digits.

xlpREDUCEFRACTION can also simplify fractions even where
simplification would not be a reduction, if desired (set the
always_simplify argument to TRUE). For example:

xlpREDUCEFRACTION(2.6,10,,TRUE)

Returns:

13/50


You'll need to download and install the Free Edition of xlPrecision:
(it never expires)

http://precisioncalc.com/xlprecision.html


Thanks,

Greg Lovern

http://PrecisionCalc.com
More Power In Excel



On Apr 28, 6:12*am, Gizmo wrote:
I am trying tofinda formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.