I have created a drop list that has four possible selections (Validation)
being A B C or D in the column next to it I want to do a check and a
calculation but I'm having problems with too many "If" scenarios <. How can
I get this to check the first column for either A, B ,C or D without my
"IF's" conflicting...

Ex:

If cell A2 = A, then A-100 (goes in cell B2)
If cell A2 = B, then B+100 (goes in cell B2)
If cell A2 = C, then C/100 (goes in cell B2)
If cell A2 = D, then D*100 (goes in cell B2)

Thank you

--
jgbadingerjr