If you are trying to build a complex formula then it
becomes tedious to remember cell address for each value to be
refered in formula.
Excel provides a facility to give names to a cell. For this
Select any cell to give name and type the name text in Name Box
found leftmost side of formula bar.
For refering a name in formula simply put Name for the cell
instead of Cell address. You can manage a formula to read more
meanfull like this, for DA =(A3*DARate), You can define DARate
on DATA sheet and enter there Rate of.
These names are unique over all sheets in a workbook.
Email US to get in touch with
us for your requirement.
