Hi! I have 2 columns with ratings A-K. One column is "incoming" rating (IB) of a period and the other "outgoing" (OB).   I'm looking to create a new column based on several conditions: 0 if no change during the period 1 if moved up 1 class, 2 if moved up 2 classes etc -1 if moved down 1 class, 2 if moved down 2 classes etc   How would one go about accomplishing this without creating one hundred case when lines?   Thank you very much 🙂 ... View more