Re: [users] Error: Invalid Name

[Andis]

I think you have to use =IF((AND(D2>5;C2>10000));2;1). This should work.

Andis

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.