XPost: comp.lang.basic.misc   
   From: donlhumphries@bigpond.com   
      
   "Lawrence Logic"  wrote in message   
   news:uI9Zo.8086$gM3.2165@viwinnwfe01.internal.bigpond.com...   
   >   
   > "DonH"  wrote in message   
   > news:80HYo.7944$gM3.2024@viwinnwfe01.internal.bigpond.com...   
   >>   
   >> (2) MOD formula in Excel won't recognise any =MOD(B6,C6), but only pure   
   >> numeric =MOD(400,60)?   
   >>   
   >   
   > I guess it depends on the values of cells B6 and C6.  =MOD(B6,C6) resolves   
   > to 1 when B6 = 10 and C6 = 3 in Excel 2003 and 2010.  That's what I'd   
   > expect.  It also worked fine when B6 and C6 were calculated based on other   
   > cells.  It looks pretty good to me.   
   >   
   > If B6 = "fred", it dies in the arse.  That's also what I'd expect.   
   >   
   > What are you doing and what were you expecting?   
   >   
   > --   
   > Lawrence   
   > "Swallow, come!" - Sea Man - 21 April 2010   
   >   
   >   
      
   # Yes, I should have persisted, instead of generalising on one instance.   
       After some initial seeming anomalies, I got my Office 2003 version of   
   Excel to work, even if MOD division by a decimal number gives inaccurate   
   result.   
        It is OK if all components are integers.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)