View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default "accept labels in formulas"

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 Backmann


"BorisS" wrote:

what is the option "accept labels in formulas", under Calculation tab of
Options?

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