scalable if function

=IF(A<1920, 50%, IF(A<3840,55%,IF(A<5760,60%,IF(A<7680, 65%,70%))))

I did not test it in Numbers, just typed it in here. Hopefully has enough closing parentheses.

Hello felixbuenobcn:

Here is the formula I believe you are looking for. Copy it then paste it into the proper cell of your table.

=IF(AND(A>0,A<=1920),50%,IF(AND(A>1920,A<=3840),55%,IF(AND(A>3840,A<=5760),60%,I F(AND(A>5760,A<=7680),65%,IF(A>7680,70%,"")))))

If your $ value is not in column A then you will need to change the A to the correct column letter.

When I copied then pasted this formula it came out with a space between the i and f of one of the if's. This space will need to be removed too.

MSwint

you can add a second table to make this very extendable:

Instead of nested if() statements, use a vlookup():

C2=VLOOKUP(B2, 'Table 1-2'::A:B, 2,TRUE)

This is shorthand for… select cell C2, then type (or copy and paste from here) the formula:

=VLOOKUP(B2, 'Table 1-2'::A:B, 2,TRUE)

fill down by selecting cell C2, copy

select cells C2 thru the end of column C, paste

Add entries in the table on the right (named table "Table 1-2") as needed

If you are trying to apply a "tiered" percentage where you have a larger amount 50% applies to the first $1920, 55% to the next $1920 after that, 60% to the the third $1920, etc. then you might clarify. That requires another approach.

SG