Due to shenanigans at work, I'm getting a lot more proactively detailed in tracking how much I'm owed for commissions, but I've never really had to get more complex with my spreadsheet formulas than '= simple math calculation.' If someone could help me out with I should write the formulas to achieve the below result, I would greatly appreciate it.
The bit where I need help is cell J2 is commission received, and K2 is commission outstanding. Column L is a Y/N variable for whether I've been paid or not. So the formula should be something like =IF(L# "Y"[L#+J2],[L#+K2]). I'm not sure how to make those values total up in the appropriate cells. Use SUMIF in some capacity?
Any assistance is appreciated.