Jun 17 2019 02:47 AM
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!
Jun 17 2019 05:16 AM
Jun 17 2019 10:08 AM
Jun 17 2019 01:30 PM
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 ) ) ) ) ) ) )
Jun 17 2019 11:43 PM
I found the solution, there was a problem with " " around the w - it was different.
Thanks for the info!