More than 7 IF(AND) statements

[alexm999]

How can I get more than 7 IF(AND) statements???

[Bryan Hessey]

try http://www.cpearson.com/excel/nested.htm

[Micayla Bergen]

i have a massive formula which i want to have a name for but i cant copy it
into the 'refers to' field. how do i put the formulas in for naming?

"Bryan Hessey" wrote:

>
> try http://www.cpearson.com/excel/nested.htm
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=390076
>
>

[Bryan Hessey]

With the cell containing the fomula selected, Insert, Name, Define, and name the item.

Had you considered entering your formula into multiple helper columns, to assist you in that it would reduce the level of complexity and the results from various stages of calculation could be checked. These helper columns can remain hidden once the formula is working.

i have a massive formula which i want to have a name for but i cant copy it
into the 'refers to' field. how do i put the formulas in for naming?

"Bryan Hessey" wrote:

>
> try http://www.cpearson.com/excel/nested.htm
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=390076
>
>