• 409K Members
• 10.4K Online
• 465K Conversations

New Contributor

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!

5 Replies

Re: problems with formula

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.

Re: problems with formula

@TwifooThe example is in the dutch language...

Re: problems with formula

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.

Re: problems with formula

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

Re: problems with formula

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

Thanks for the info!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
18 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies