Forum Discussion

sylviewal's avatar
sylviewal
Copper Contributor
Jun 17, 2019

problems with formula

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!

excel
Formulas and Functions

5 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jun 17, 2019
    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.
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jun 17, 2019

        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
                  )
               )
            )
         )
      )
   )
)