# Contains too many arguments

1. ## Contains too many arguments

I have a formula a have not figured out a way to shrink down to operable levels.. can anyone assist me? I know it looks very daunting but the equation its self is simple I just cant figure out a way to condense it.

=IF(H9<100%,IF(F8<85%,0,IF(F8<90%,50%,IF(F8<100%,75%,IF(F8<115%,F8,IF(F8<125%,110%,IF(F8<175%,125%,IF(F8>=175%,125%))))))),IF(H9<110%,IF(F8<85%,0,If(f8<89.9%,75%,If(f8<99.9%,75%,If(f8<114.9%,F8,If(f8<124.9%,125%,If(f8<149.9%,150%,If(f8<174.9%,175%,If(f8>=175%,F8,))))))))),If(h9>=110%,If(f8<84.9%,0%,If(f8<89.9%,75%,If(f8<99.9%,75%,If(f8<114.9%,F8,If(f8<124.9%,135%,If(f8<149.9%,160%,If(f8<174.9%,185%,If(f8>=175%,F8,))))))))))

The formula will function until the last " If(h9>110%

Thanks a ton!!  Register To Reply

2. ## Re: Contains too many arguments

Welcome to the board.

Maybe this: ``Please Login or Register  to view this content.``  Register To Reply

3. ## Re: Contains too many arguments

Formula:  `Please Login or Register  to view this content.`  Register To Reply

4. ## Re: Contains too many arguments

Thank you so much for the input. im at work now and in between checking the thread I created a working version as follows..

=IF(H9<100%,IF(F8<85%,0,IF(F8<90%,50%,IF(F8<100%,75%,IF(F8<115%,H9,IF(F8<125%,110%,IF(F8<175%,125%,IF(F8>=175%,125%))))))),IF(H9<110%,IF(F8<85%,0,IF(F8<89.9%,75%,IF(F8<99.9%,75%,IF(F8<114.9%,H9,IF(F8<124.9%,125%,IF(F8<149.9%,150%,IF(F8<174.9%,175%,IF(F8>=175%,H9,)))))))),IF(F8<84.9%,0%,IF(F8<89.9%,75%,IF(F8<99.9%,75%,IF(F8<114.9%,H9,IF(F8<124.9%,135%,IF(F8<149.9%,160%,IF(F8<174.9%,185%,IF(F8>=175%,H9,))))))))))

but thank you so much for the assistance! as I'm not the most fluid with excel anymore I know my formula is much more bulky but its getting the job done! haha  Register To Reply

5. ## Re: Contains too many arguments  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 