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.

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.

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.

=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.