View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kdoggity
 
Posts: n/a
Default Associated Numerical Values

I'm trying to create a formula that references two cells. In each of the
cells is a drop down box with three options. The options aren't numbers. Is
there a way to associate values to those options so that the formula will
result in a numerical total?