B
Bob Ptacek
I have a numeric field with values 1,2 or 3 referenced by a label in an array
formula. I thought that previous formula where condition LABEL=1 worked,
but it now it has to be LABEL="1".
Unfortunely it's in a file not frequently used so I can't prove that LABEL=1
ever work.
So I was wondering if anyone knows if there has been a SP to Excel 2003 that
might now require quotes for a conditional check of a numberic field or is my
memory bad and this never should have worked in the first place.
Thanks in advance for any insight
formula. I thought that previous formula where condition LABEL=1 worked,
but it now it has to be LABEL="1".
Unfortunely it's in a file not frequently used so I can't prove that LABEL=1
ever work.
So I was wondering if anyone knows if there has been a SP to Excel 2003 that
might now require quotes for a conditional check of a numberic field or is my
memory bad and this never should have worked in the first place.
Thanks in advance for any insight