Thanks Tom, Sorry I wan't clear enough!

There are a whole bunch of possible values and outcomes, way too many
for a nested IF statement approach.

I was looking for a VB solution something along the lines of Case or If
?