G
Guest
I have 6 columns N1, N2 thru N6
How do I, in a single field, say IF (N1, N2, N3, N4, N5, N6 = 1 then 1 else
"")
Basically, if any fields = 1, then display that value.
At any time, only 1 of the fields would be 1, if any.
Thanks in advance.
How do I, in a single field, say IF (N1, N2, N3, N4, N5, N6 = 1 then 1 else
"")
Basically, if any fields = 1, then display that value.
At any time, only 1 of the fields would be 1, if any.
Thanks in advance.