Help with a formula and cell referencing.
 

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.

Help with a formula and cell referencing.
 

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

Insert Name Define

and see if the names appear.
--
Gary''s Student - gsnu200805


"Jorge" wrote:

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.

Help with a formula and cell referencing.
 

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.


"Jorge" wrote in message
...
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.

Help with a formula and cell referencing.
 

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

As a side note, if you are using Excel 2007...

=IFERROR((100*y)/(n + y),"")

--
HTH :)
Dana DeLouis


"Gary''s Student" wrote in message ...

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

Insert Name Define

and see if the names appear.
--
Gary''s Student - gsnu200805


"Jorge" wrote:


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.