XPost: comp.lang.basic.misc   
   From: lawrence-OmitThisBit-logic@amd-p.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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)