Help with a formula and cell referencing.

[Jorge]

Hello,

I am currently working on a spreadsheet that was handed down from someone
else and I am having trouble understanding one of the formulas.

=IF(ISERROR((((Y/(Y+N))*(100-(Y+N)*14))+(Y*14))),"",(((Y/(Y+N))*(100-(Y+N)*14))+(Y*14)))

I know how it works, and I know what it does. However, I can not figure out
how this formula knows what range of information to use to gather
information, yet in the spreadsheet each cell with this formula has a range
associated with it.

Any assistance would be appreciated.

 

[Gary''s Student]

Y and N are probably Named Ranges. To verify this, checK:

Insert > Name > Define

and see if the names appear.

 

[Gaurav]

There must be named ranges. Go to the box on top left of the worksheet which
shows the cell address of the active cell. Type Y or N there and press
enter...see what range is selected.