View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
100pinesfarm 100pinesfarm is offline
external usenet poster
 
Posts: 4
Default HOW DO I GO TO DIFFERENT CELLS BASED ON WHAT IS IN A CERTAIN CELL

example:
IF(OR(F3="BD",F3="CD"),B6,C6)

if cell "F3" is a certain value my formula requires different cell values,
this may occur numerous times in a formula, so I would like to have a shorter
way to say it.
"F3" has a limited (@4) different possibilities, but the "OR" combinations &
the goto's are quite numerous.
Thanks for any help!
Nick