software

what is the option quot;accept labels in formulasquot;, under Calculation tab of
Options?

I read the help, but it doesn't make sense to me. Thanks.
--
Boris

If there is a label to the left of a value the formula will reference the
label text in the formula, while picking up the associated values. It can be
useful when trying to identify what the value is associated with in complex
formulas. You can produce the same result by naming a range.

Salary 1.500.00
Deductions 345.55
Insurance 288.22

Using labels the formula to produce Net Pay would be
Salary-Deductions-Insurance

--
Kevin Backmannquot;BorisSquot; wrote:

gt; what is the option quot;accept labels in formulasquot;, under Calculation tab of
gt; Options?
gt;
gt; I read the help, but it doesn't make sense to me. Thanks.
gt; --
gt; Boris

Hi Boris, Kevin,

However, it is not very well developed. There are problems if you try to reference other sheets, name conflicts do not show
clearly, UDF's behave unreliably, intersection doesn't seem to work as it should, the labels do not show up in the Paste Names
menu, etc.
General advice (not just mine!) is not to use this feature.

--
Kind regards,

Niek Otten

quot;Kevin Bquot; gt; wrote in message ...
gt; If there is a label to the left of a value the formula will reference the
gt; label text in the formula, while picking up the associated values. It can be
gt; useful when trying to identify what the value is associated with in complex
gt; formulas. You can produce the same result by naming a range.
gt;
gt; Salary 1.500.00
gt; Deductions 345.55
gt; Insurance 288.22
gt;
gt; Using labels the formula to produce Net Pay would be
gt; Salary-Deductions-Insurance
gt;
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;BorisSquot; wrote:
gt;
gt;gt; what is the option quot;accept labels in formulasquot;, under Calculation tab of
gt;gt; Options?
gt;gt;
gt;gt; I read the help, but it doesn't make sense to me. Thanks.
gt;gt; --
gt;gt; Boris
I personally don't use it but if you have it checked and you have a header
(label) called Amounts in A1 and numbers in A2:A10, instead of using

=SUM(A2:A10)

you can use

=SUM(Amounts)--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;BorisSquot; gt; wrote in message
...
gt; what is the option quot;accept labels in formulasquot;, under Calculation tab of
gt; Options?
gt;
gt; I read the help, but it doesn't make sense to me. Thanks.
gt; --
gt; Boris