problems with formula

[sylviewal]

Hi

I'm experiencing a problem with this formula I made:

=ALS(OF(C21="r";C21="x";C21=”w”;C21="ta";C21="ao";C21="oa");0;ALS(C21=rec;C22;ALS(C21=v;7,6;ALS(OF(C21=wf;C21=z;C21=kv;C21=cd;C21=bv);8;ALS(EN((C22-C21)>5;(C22-C21)<=11;C21>0;C21<12);C22-C21-0,5;ALS(EN((C22-C21)>=6;C21>12;C22>=19);C22-C21-1,5;ALS(EN((C22-C21)>10;C21<12;C22>20);C22-C21-2;C22-C21)))))))

It gives me a #NAME troubleshoot ...

Is there anyone who can help me to fix this?

Thanks!

[#2]

Excel does not recognize these purportedly defined names in your formula:
ALS, OF, rec, v, wf, z, kv, cd, bv, EN
Also, Excel does not recognize the formula for being constructed with incorrect syntax.

[#3]

@TwifooThe example is in the dutch language...

[#4]

Please verify whether those I enumerated represent a function name or a defined name. Except for ALS, OF, and EN, all others are purported names that were not defined. Thus, Excel doesn’t recognize them as names and returns the #NAME? error.

[#5]

@TexelFred 

Perhaps

=ALS(
   OF(C21="r";C21="x";C21="w";C21="ta";C21="ao";C21="oa");
   0;
   ALS(C21="rec";
      C22;
      ALS(C21="v";
         7,6;
         ALS(
            OF(C21="wf";C21="z";C21="kv";C21="cd";C21="bv");
            8;
            ALS(
               EN((C22-C21)>5;(C22-C21)<=11;C21>0;C21<12);
               C22-C21-0,5;
               ALS(
                  EN((C22-C21)>=6;C21>12;C22>=19);
                  C22-C21-1,5;
                  ALS(
                     EN((C22-C21)>10;C21<12;C22>20);
                     C22-C21-2;C22-C21
                  )
               )
            )
         )
      )
   )
)

[#6]

I found the solution, there was a problem with " " around the w - it was different.

Thanks for the info!