Thanks, can you recommend a different type of formula that I should learn if
I need to use more than 7 if's in a single formula?

"Marcelo" wrote:

> Kim, excel does not support more than 7 if's
>
> hth
> regards from Brazil
> Marcelo
>
> "Kim" escreveu:
>
> > My formula below is working perfectly...EXCEPT, I want to add one more IF to
> > the end, I want to add IF(C17="12x", 6%,""....but it won't let me add this.
> > Am I limited to the number of IF's in one formula? Also - can I use just the
> > number 1, rather than 1x, 2x, 3x...? When I use just the 1, 2 or 3 by itself
> > it gives me a blank. I just can't figure it out - I greately appreciate your
> > help!!!!!!!!!!!!!!!!!
> >
> > =IF(C17="1x",0%,IF(C17="2x",0%,IF(C17="3x",0%,IF(C17="4x",2%,IF(C17="6x",4%,IF(C17="9x",6%,IF(C17="10x",6%,IF(C17="11x",6%,""))))))))
> >
> >