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!!
Bookmarks