You are limited to 7 IF Statements nested together in a single cell.
You are returning the same results for 1x, 2x and 3x (0%). Also, 9x, 10x,
11x, 12x (6%). You can combine these in an OR function:
=IF(OR(C17={"1x","2x","3x"}),0%,IF(C17="4x",2%,IF(C17="6x",4%,IF(OR(C17={"9x","10x","11x","12x"}),6%,""))))
If you want to use just 1, 2, 3... instead of 1x, 2x, 3x... make sure that
C17 contains just those numbers, then change your formula accordingly.
HTH,
Elkar
"Kim" wrote:
> 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%,""))))))))
>
>
Bookmarks