GCD_Dilemma

Posts: n/a

GCD Function doesn't work in some cases

How come the following in Excel 2003:
=GCD((1.4-1)*10,10)
yields 1 rather than 2, but
=GCD((0.4)*10,10)
yields the correct answer 2 ?
=GCD(4,10)
also correctly yields 2 !
(I've broken down this formula into its simplest elements;
the numbers normally will be filled with variables or cell references.)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Averaging function	Sarah	Excel Discussion (Misc queries)	0	January 18th 05 04:09 PM
Accessing a Function	Bill Martin -- (Remove NOSPAM from address)	Excel Discussion (Misc queries)	4	January 1st 05 05:46 AM
Function in XL or in VBA for XL that pulls numeric digits from a t	Nate Oliver	Excel Discussion (Misc queries)	0	December 14th 04 04:57 PM
change function variable prompts??	thinkingfield	Excel Worksheet Functions	1	November 8th 04 04:01 PM
SUMIF(AND) FUNCTION	Saariko	Excel Worksheet Functions	9	October 28th 04 11:52 AM

All times are GMT +1. The time now is 01:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us