View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default 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?