Help with a formula and cell referencing.

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

Gary''s Student

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

Insert > Name > Define

and see if the names appear.
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top