|You're absolutely right, it's was suppose to be I142, which still didn't work. I've also updated the <200 to say <=200, and that works out. |
The reason I subtracted 125, then added 200 is b/c after SUM(B12:B49)*1.60 exceeds $200, you multiply the remaining amount by 1.07, H142.; 200/1.6=125.
So 125 x 1.6 = 200 (which is the max it can be)
Then, ((SUM(B12:B49)-125)*H142) = the remaining amount using the 1.07 mulitplier
Then, +200 to = total amount w/ both multipliers.
I'm sorry if I didn't make that very clear. I guess I should have said the multiplier changes after the first 200 is reached, but then the remaining amount is multiplied by 1.07.
Again, thank you for your help.