Page 1 of 1

ERR in cells

Posted: Thu Mar 21, 2019 10:34 am
by bunchukokoy
Hi guys,

Has anyone encountered this one? I don't see anything wrong with the rules, but it returns ERR in the cells.
The issue seems to be in the right part of &.
I tried DB, tried ATTRS. Didn't work.

Thanks in advance.
Capture.PNG
Capture.PNG (18.51 KiB) Viewed 2246 times

Re: ERR in cells

Posted: Thu Mar 21, 2019 12:27 pm
by Wim Gielis
What happens if you:
- do a Trace calculation on any of the cells ?
- limit to 1 condition to test, instead of having 2 conditions ?
- hardcode certain functions / references ?
- swap places for !}Groups and ATTRS( ... ) (switch left hand side and right and side of the equation) ?

Re: ERR in cells

Posted: Thu Apr 04, 2019 1:41 am
by bunchukokoy
Hi Wim,

Sorry I didn't get back. Yeap, nested if solved it. Thanks.