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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|