Help with a formula and cell referencing.

  • Thread starter Thread starter Jorge
  • Start date Start date
J

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.
 
Y and N are probably Named Ranges. To verify this, checK:

Insert > Name > Define

and see if the names appear.
 
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.
 
Back
Top