Yes, it does help a lot! I was using commas instead of semicolons and was looking at a filtered list of functions. The expression I had was =CHAR(MOD(A1,26)+64) and when I got the error I clicked on the Fx function Wizard button on the address bar and didn't notice that it was filtered to Text functions at that point.
Thanks for your help and for your speedy response Regards, Paul Bennington On Sat, Apr 26, 2008 at 2:32 PM, Brian Barker <[EMAIL PROTECTED]> wrote: > At 13:58 26/04/2008 +0100, Paul Bennington wrote: > > > I am trying to use the MOD function in Calc and keep getting #NAME? > > errors. I then checked and found that the MOD function is not listed. > > However, I have seen other users post that they have been using this > > function - what do I have to do to switch it on? > > > > I'm not sure where you are looking, but the MOD() function does exist in > Calc. It is listed in the help text (under Mathematical Functions) and > appears in the Function Wizard - again under Mathematical. > > If you are seeing #NAME?, one possibility is that you are separating the > parameters with a comma (Excel style), rather than with semi-colon that Calc > requires. > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
