Quote Originally Posted by Paul View Post
What are all of the SUM and PRODUCT functions doing? They're probably unnecessary. Your formula in cell D16:

=IF($B16="","",IF(AND($B16=0,SUM($A16)=SUM($F$7)),SUM(PRODUCT($D15,0.75)),IF(AND($B16=0,SUM($A16)=SUM($F$8)),SUM(PRODUCT($D15,0.5)),IF(AND($B16=0,SUM($A16)=SUM($F$9)),SUM(PRODUCT($D15,0.25)),IF(AND($B16=0,SUM($A16)=SUM($F$10)),SUM(PRODUCT($D15,0)),SUM($D15,$B16))))))

...can probably be written as:

=IF($B16="","",IF($B16=0,$D15*CHOOSE(MATCH($A16,$F$7:$F$10,0),0.75,0.5,0.25,0),$D15+$B16))
I was running though a lot of help forums and text manuals and they were recommending to add the SUM and PRODUCTS to make the equation clearer, but it shows that yours is more simplistic and works just as well thank you a lot on that one. Now if we can just solve the other 800 million problems with it, jk. LMAO