You said to begin with that you had more than 7 variables, so you
couldn't use IF .. THEN. The VLOOKUP formulae will give you what you
want - you just need to define a table somewhere with the values you
expect in A1 and the derived values you want in G1 and then enter the
Vlookup formula in G1. If your table covers, say, Y1:Z15, then ensure
the range in the lookup formula is Y$1:Z$15, then you can copy this
down column G for as many values that you have in column A.

Pete