if then statement in VB
Is your example true to life, or just an example? If it's true to
life, then instead of code you might use just a formula in the other
cell:
=A2/5
Or, you might insert a new tab that holds lookup values, and on the
original sheet use VLOOKUP formulas to return a value corresponding to
the value in A2. Might these ideas work for you?
|