Multiple IF statements in one cell

It seems that I can only put 7 IF statements in one cell. Is there any way
that I can put more than just 7 IF statements in one cell? I'm looking to
use atleast 10.

try chip pearson's site
http://www.cpearson.com/excel/nested.htm

--


Gary


"Jones E" <JonesE@discussions.microsoft.com> wrote in message
news:48656DA5-8286-4FE2-952F-A0909C5D1BF5@microsoft.com...
> It seems that I can only put 7 IF statements in one cell. Is there any way
> that I can put more than just 7 IF statements in one cell? I'm looking to
> use atleast 10.

=IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;)))))))+IF(1=1;IF(1=1;1;0))


"Gary Keramidas" skrev:

> try chip pearson's site
> http://www.cpearson.com/excel/nested.htm
>
> --
>
>
> Gary
>
>
> "Jones E" <JonesE@discussions.microsoft.com> wrote in message
> news:48656DA5-8286-4FE2-952F-A0909C5D1BF5@microsoft.com...
> > It seems that I can only put 7 IF statements in one cell. Is there any way
> > that I can put more than just 7 IF statements in one cell? I'm looking to
> > use atleast 10.
>
>
>

Thanks for your help

"excelent" wrote:

> =IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;)))))))+IF(1=1;IF(1=1;1;0))
>
>
> "Gary Keramidas" skrev:
>
> > try chip pearson's site
> > http://www.cpearson.com/excel/nested.htm
> >
> > --
> >
> >
> > Gary
> >
> >
> > "Jones E" <JonesE@discussions.microsoft.com> wrote in message
> > news:48656DA5-8286-4FE2-952F-A0909C5D1BF5@microsoft.com...
> > > It seems that I can only put 7 IF statements in one cell. Is there any way
> > > that I can put more than just 7 IF statements in one cell? I'm looking to
> > > use atleast 10.
> >
> >
> >