Rakesh handa
Rakesh_handa81@yahoo.co.in
Rakesh_handa81@yahoo.co.in
BUILD A FORMULA USING LABELS INSTEAD OF CELL
ADDRESSES
With these formulas, you can use
the headings in a worksheet to describe which cells you want to
reference.
To enable them, go to
Tools - Options - Calculation and select Accept Labels in Formulas,
as shown in the below fig.
That will give the ans. as 32
To
refer to sales of ABC in the West, you would enter =West ABC, or
=ABC West, as shown in below Fig.
That will give the ans. as 32
You can even
figure out the Gross Profit on a Gross quantity, as shown in Fig
below
