Here is what I have at the moment. Don't mind the extra junk at the bottom, those are just my notes I pulled from the reading. ha.

Rows 12-14 are where I am working. I have the change between the 2 numbers, but I need to know if it was an increase or decrease, then have it do the math based on if its a decrease or increase. With the before/after section on those same lines, I need to know if they are between the range numbers or not as well. I would like something to visually show or tell me it's not in the range.

With this, I get charged for increasing, but I do not get charged anything if I decrease or stay the same.

Marketing Game - Formulas Sheet.xlsx