HELP! Nested IF statements driving me insane!

J

Jimmy

Perhaps I'm a little too tired, because I'd swear I've made this work before.
But I'm stuck and am ready to ask for help! :)

I have some IF functions that I need to nest together, but I keep getting
the "too many arguments" error. Does anyone have any suggestions on how I
might either get around the error or reformat the function so that it
works??? Open to all suggestions.

Here are the IF statements that I need to string together:

=IF(J32<12201,(J32*.22))

=IF(J32<15401,(((J32-12200)*.25)+2684))

=IF(J32<18501,(((J32-15400)*.29)+3484))

=IF(J32<21601,(((J32-18500)*.34)+4383))

=IF(J32<24701,(((J32-21600)*.40)+5437))

=IF(J32>=24701,(((J32-24700)*.47)+6677))

Thanks!
 
F

Frank Kabel

Hi
try:

=IF(J32<12201,J32*.22,IF(J32<15401,(J32-12200)*.25+2684,=IF(J32<18501,(
J32-15400)*.29+3484,IF(J32<21601,(J32-18500)*.34+4383,IF(J32<24701,(J32
-21600)*.40+5437,(J32-24700)*.47+6677)))))

Still wondering if your first value of 12200 is correct as for all
other values you have a difference between them of 3,100. Only for the
first two values the difference is 3,200
 
T

Trevor Shuttleworth

Jimmy

try:

=IF(J32<12201,J32*0.22,IF(J32<15401,(J32-12200)*0.25+2684,IF(J32<18501,(J32-15400)*0.29+3484,IF(J32<21601,(J32-18500)*0.34+4383,IF(J32<24701,(J32-21600)*0.4+5437,(J32-24700)*0.47+6677)))))

Regards

Trevor
 
H

hgrove

Jimmy wrote...
...
I have some IF functions that I need to nest together, but I kee getting the
"too many arguments" error. Does anyone have any suggestions on ho I
might either get around the error or reformat the function so that i works???
Open to all suggestions.

Here are the IF statements that I need to string together:

=IF(J32<12201,(J32*.22))

=IF(J32<15401,(((J32-12200)*.25)+2684))

=IF(J32<18501,(((J32-15400)*.29)+3484))

=IF(J32<21601,(((J32-18500)*.34)+4383))

=IF(J32<24701,(((J32-21600)*.40)+5437))

=IF(J32>=24701,(((J32-24700)*.47)+6677))
Click to expand...

Another alternative that would scale more easily if you ever need mor
than 8 tiers.

=SUMPRODUCT(--(J32>{0;12200;15400;18500;21600;24700}),
J32-{0;12200;15400;18500;21600;24700},{0.22;0.25;0.29;0.34;0.4;0.47})
-SUMPRODUCT(--(J32>{12200;15400;18500;21600;24700}),
J32-{12200;15400;18500;21600;24700},{0.22;0.25;0.29;0.34;0.4}
 
Top