Number& and Date&

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


1 comment

Please sign in to leave a comment.