Forum Discussion
sylviewal
Jun 17, 2019Copper 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...
Twifoo
Jun 17, 2019Silver Contributor
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.
ALS, OF, rec, v, wf, z, kv, cd, bv, EN
Also, Excel does not recognize the formula for being constructed with incorrect syntax.
- SergeiBaklanJun 17, 2019Diamond Contributor
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 ) ) ) ) ) ) )- sylviewalJun 17, 2019Copper Contributor
I found the solution, there was a problem with " " around the w - it was different.
Thanks for the info!
- TwifooJun 17, 2019Silver ContributorPlease 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.