On Saturday 25 November 2006 08:47 pm, BaX wrote: > When I insert the following formula: =IF((AND(D2>5,C2>10000)), 2,1) > into a cell and press the Enter key, #NAME? appears in the cell and > the error message at the bottom right of Calc indicates Error: > Invalid name.
From another member of this mailing list: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I think you have to use =IF((AND(D2>5;C2>10000));2;1). This should work. Andis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]