If function with multiple inputs that returns text strings with variable

Question

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:

Answer 1

Assuming your table is in A1 to E7.

Place the following formula in E2 and copy down

=IF(AND(A2=C2,B2=D2),"Keep Same",IF(A2<>C2,IF(A2>C2,"Delete ","Add ")&ABS(A2-C2)&" card"&IF(ABS(A2-C2)<>1,"s",""),"")&IF(AND(A2<>C2,B2<>D2),"; ","")&IF(B2<>D2,"Change Std Pack to "&D2,""))

Note the following part from the formula above is optional. It is just taking care of placing the s on the end of card when there is more than 1 card being added or deleted.

&IF(ABS(A2-C2)<>1,"s","")