Essentially I have 4 columns of values I'm pulling from.
A: "Old # of Cards"
B: "Old Std Pack Qty"
C: "New # of Cards"
D: "New Std Pack Qty"
In a separate column E, I comment what changes need to be made.
If all values stay the same then I write "Keep Same"
If the A > C "Delete X card(s)" or if A < C "Add X card(s)" where X = A-C or C-A
If B ≠ D "Change Std Pack to Y" where Y = B-D or D-B
Also if A ≠ C and B ≠ D then "Add/Delete X Card(s); Change Std Pack to Y"
I almost had it figured out with a bunch of nested if(and's but I'm struggling with getting that "X" variable between the "Add/Delete" and the "card(s)". Also not sure if it's possible to pluralize the "card" if > 1. I'm sure there may be an easier way that doesn't involve the if formulas but I'm not sure what that would be.
Here is what my table would look like: