Hi experts,
I need a logical explanation for the control commands number & and date&
The following two functions work without errors.
=NL("rows";"item";;"Qty. on Sales Order";"<70&<>0")
=NL("rows";"item";;"=NF(;""Qty. on Sales Order"")+NF(;""Qty. on Purch. Order"")";"Number&"&"<70&<>0")
But why do I need the "number&" before the cell reference in the 2nd function? What does this do?
And Do you have an example for the use of "date&"?
Thanks for your help.
Best Regards
Frank